Word 365 ProPlus English

Which Are The Updated Features for Info for our Office Files;

Posted on

In Microsoft Office applications, most of the information that we need about our actual active Document, Workbook or Presentation are available in one location. This location is the Info pane of the Backstage View. In this location, we can access information about permissions, prepare our content for sharing, recover if possible unsaved Files. Now available are even more commands available for us to use, which will be described in the post below. Just keep on reading to find out how to Upload, Share, Copy Path and even Open the File Location in Microsoft Word, PowerPoint and Excel.

Updated Info about Microsoft Office 365 Programs

Read the rest of this entry »

Advertisements

How To Recover Unsaved Microsoft Office Files?

Posted on

Let’s say that we have put a lot of effort typing in our Word Document or creating an Excel Workbook or even finalizing our PowerPoint Presentation. Suddenly they are gone! We haven’t even saved them. What happens next? How do we Recover them? Thankfully, it is not that hard to Recover our Word Documents, Excel Workbooks and PowerPoint Presentations in the recent versions of Microsoft Office. This is where the Recover Unsaved Files Feature appears in Microsoft Office and will be described in the post below.

Recover Unsaved Office Files

Read the rest of this entry »

What Is The Touch/Mouse Mode Feature Available in Microsoft Office Applications?

Posted on

A new feature available in Microsoft Office applications, is the Touch/Mouse Mode. What does this feature do? It increases or leaves the same, the spacing between the commands of the ribbon in Microsoft Office applications. Touch Mode lets us use the program even without a mouse if our device supports it by increasing the spacing. Mouse Mode lets us use the program with our mouse. To learn more about the feature Touch/Mouse Mode, just keep on reading the post below.

New Touch Mode Feature Available in Office Programs

Read the rest of this entry »

How To Change The Page Numbering Order In An Excel Spreadsheet?

Posted on

Many times, and Excel Spreadsheet doesn’t fit on one page because it is too large. Cells are pushed to another page, and depending how we have organized our data, we sometimes need to change the order of the pages manually so it could be easier for the viewer. Sometimes additional Columns will be printed at the end of the Sheet, after all the Rows have been printed and many other issues also occur. If you want to change the order of our Pages in our Excel Spreadsheet just keep on reading.

How To Change The Page Order in Excel

Read the rest of this entry »

How To View, Insert or Edit Page Breaks in Excel

Posted on

Page Breaks are dividers that separate our Worksheet into different pages for printing. In Excel, automatic Page Breaks are inserted depending on the Paper Size, Margin Settings, Scale Options and the positions of the Manual Page Breaks that we have inserted. If we want to Print a Worksheet with the exact number of Pages that we want, we must adjust the Page Breaks in our Worksheet before we print it. To find out, how it is done, just keep on reading the post below.

Insert - Delete - Review Page Breaks in Excel

We must select the View tab, and then from the left area of the ribbon we locate the area named Workbook Views as shown in the image below.

View Tab - Workbook Views - Page Break Preview

Once we locate the Workbook Views area, we select the command Page Break Preview, where we will be able to See Where The Page Breaks Will Appear When Our Document Is Printed.

Page Break Preview

In the image below, I have selected the Page Break Preview, where we can see the actual page that will be printed when we decide to. We notice the Page 1 lettering in the middle of the Spreadsheet (which will not be printed) and we notice a Horizontal and Vertical Blue Line which define where the Page ends. The Horizontal and Vertical Blue Line defines a Manual Page Break that we have inserted.

Page Break Preview

If we need to adjust the Page Break manually, all we need to do is to click and select either the Horizontal or Vertical Line, or where the lines intersect at the bottom right corner and then drag them with our mouse to the position needed as shown in the image below.

Page Break Preview

Once we have dragged the lines to the position needed, we notice now that we have four (4) Pages in our Spreadsheet. We also notice that the Pages order goes from Top to Bottom and then from Left to Right, a feature that can be changed and will be described in a future post of mine. We also notice that we have besides the Straight Blue Lines (both vertical and horizontal), Dotted Blue Lines Vertical and Horizontal. The Dotted Blue Lines Vertical and Horizontal means that they are Automatic Page Breaks.

Page Break Preview

If we want to Insert our own Page Breaks and not to use the Automatic ones, we must select the Page Layout tab and then locate the area of the ribbon named Page Setup as shown in the image below.

Page Layout Tab - Page Setup Area

Once we have located the Page Setup area of the Page Layout tab, we select the command Breaks as shown in the image below. Once we select the command Breaks, from the drop-down menu that appears we have the following commands available and which are:

  • Insert Page Break: A Page Break will be inserted depending which is the activated Cell in our Spreadsheet.
  • Remove Page Break: The Manual Page Break that was inserted will be removed.
  • Reset All Page Breaks: All the Manual Page Breaks will be removed and only the automatic page breaks will be displayed.

If we want to Insert a Vertical Page Break, we must select the Row below where we want the Page Break to be Inserted.

If we want to Insert a Horizontal Page Break, we must select the Column to the right of where we want the Page Break to be Inserted.

Page Setup - Insert Breaks

Another way to Insert a Page Break in our Spreadsheet, we just activate the Cell needed and then do a right click with our mouse. From the shortcut menu that appears we select the command Insert Page Break as shown in the image below.

Insert Page Break Short Cut Menu

The procedure is quite easy and simple for us to Insert Page Breaks in Excel. When we open our Worksheet or an entire Workbook in Excel, we are not able to see where the pages begin and where they end. All we see are the Cells that are part of the Spreadsheet. As mentioned, for us to see the Page Breaks we must locate the Workbook Views area, and then select the command Page Break Preview

Below you can check out the video describing How To View, Insert or Edit Page Breaks in Excel.

Don’t Forget To Subscribe To My YouTube Channel.

YouTube Channel

How To Copy or Move A Worksheet in Excel?

Posted on

In Excel, we can Move or Copy a Worksheet in the same Workbook so we can organize the Workbook the way we want to, or we can even Move or Copy a Worksheet to other location, such as an existing open Workbook or to a New Workbook. All you need to do, so you can find out how, is to continue reading this post below.

How To Move Or Copy A Spreadsheet in Excel

Read the rest of this entry »