Category Archives: Excel 365 English

How To Maximize Printing Options in An Excel Spreadsheet?

When we look on a Spreadsheet in Excel on a Monitor, everything looks just perfect. Sometimes though, when we want to Print it, if we are not careful we will be ending up wasting a lot of Paper and we will not have a clue what has been Printed. Data here, Columns there, Rows everywhere. Everything will just be Printed out of order. This is where the Backstage Printing Options comes along, where we can adjust the Paper Size and even the Orientation of the Page. To find out how to Maximize the Printing Options in an Excel Spreadsheet, just keep on reading the post below.

How To Maximize Printing Options in Excel

Read the rest of this entry

How To Insert A Watermark in an Excel Spreadsheet?

Watermark is an image or text that appears usually behind the main Document or Spreadsheet. For example, Watermarks usually displays the status of the Document or Spreadsheet such as “Confidential”, “Copyright” among others. Watermark can either be text or even images, such as our logo or other pictures. Inserting a Watermark is an easy procedure and has been describe in a previous post of mine, but inserting a Watermark in an Excel Spreadsheet is a bit tricky and will be described in the post below, so just keep on reading.

How To Insert A Watermark on a Spreadsheet in Excel

Read the rest of this entry

How To Insert A Sheet Background in An Excel Workbook?

In Microsoft Excel, we can set a Picture as a Sheet Background. This Sheet Background will be used only for display purposes and cannot be printed. Because a Sheet Background cannot be printed, therefore cannot be used as a Watermark. In a next post of mine I will describe how to insert a Watermark in an Excel Spreadsheet. For now, I will be describing How To Insert A Sheet Background in An Excel Spreadsheet. Just keep on reading the post below.

How To Insert A Background on a Spreadsheet in Excel

Read the rest of this entry

How To Modify The Calculation Options in a Microsoft Excel Workbook?

In Microsoft Excel, all the currently open Workbooks, use the same of Calculation no matter in which mode we have saved them. For to use different Calculation Modes, we must use different procedures to work with Workbooks that use different Calculation Modes. By default, the mode set to recalculate in an Excel Workbook is automatically. If we make any changes in a cell that is referenced in a Formula, Excel will automatically recalculate the Formula so that it returns a correct result based on the changes. Keep in mind, that if the Formula that it recalculates and is used as a Cell Reference in other Formulas, all the other Formulas that is dependent on the recalculated Formula will also be recalculated. To find out how to Modify the Calculation Options in an Excel Workbook just keep reading the post below.

How To Modify Calculation Options in Excel

Read the rest of this entry

How To Change Default Layout Of PivotTables in Excel?

Imagine that we have an existing PivotTable laid out exactly the way we want it to be, where we have spent a lot of time on it. What happens to those settings though? Do we have to repeat them again and again for future PivotTables that we create? Well, it is possible to import these settings, otherwise will have to edit them one by one, individually. If we change the Default Settings of a PivotTable, all these settings will take place to all the new PivotTables in all future Workbooks. PivotTables that already exist, will not be affected at all by the changes that are made to the Default Layout. If you want to find out, how to modify and change the Default Layout of PivotTables just keep on reading the post below.

How To Change Default Layout Of PivotTables in Excel

Read the rest of this entry

How To Recover Unsaved Microsoft Office Files?

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

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

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

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

Read the rest of this entry

How To Copy or Move A Worksheet in Excel?

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

How To Delete Cells, Rows, Columns and Spreadsheets in an Excel Workbook?

In a previous post of mine, I had mentioned How To Insert Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook. What happens though, when we come to a point that we want to Delete Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook. All you need to do is to continue reading this post.

How To Delete Cells, Rows, Columns & Sheets in Excel

Read the rest of this entry

%d bloggers like this: