web analytics

Tag Archives: Microsoft Office 2013

HOW TO SPLIT THE MICROSOFT EXCEL 2013 WORKSHEET INTO WINDOWS

Microsoft Excel 2013

This article is about splitting worksheets in Microsoft Excel 2013. Although zooming in and out on the worksheet can help you get your bearings, it can’t bring together to separate sections so that you can compare their data on the screen. To manage this split the worksheet area in two separate panes and then scroll the work it did each panes so that they display the parts you want to compare.

Splitting the window is easy. To split a worksheet independent you simply position the cell pointer at the place in the worksheet where you want to split the worksheet and then click the split button.

1

USING THE AUTO RECOVER FEATURE IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article will show you how to use the document recovery feature that Microsoft Excel 2013 offers in case your computer crashes. This auto recover feature will save all of your workbooks at automatically set regular intervals. If a computer crash occurs, Microsoft Excel 2013 will display a recovery task pane of your document when you launch your Microsoft Excel 2013 workbook again after you reboot your computer.

1

USING AND DOWNLOADING EXISTING WORKBOOK TEMPLATES IN MICROSOFT EXCEL 2013 – PART 2

Microsoft Excel 2013

This is PART 2 of the article.

Suppose you have done some formatting on your workbook and you want to save it like a template so you can use it again in future. There are few steps that you need to follow:

01 - Options tab

USING AND DOWNLOADING EXISTING WORKBOOK TEMPLATES IN MICROSOFT EXCEL 2013 – PART 1

Microsoft Excel 2013

This article is about creating and using Excel templates which provide creating workbooks, worksheets and charts. The templates have the necessary formulas and formatting for creating reports that you need to create very often and they have the template as their base. This could save you a lot of time when you have to make similar formatting. Excel supports several types of templates for workbooks, worksheets and charts:

  • The Predefined templates that are already created by “MS Office” and are available for download.
  • The default templates which you can insert every time you need a new workbook, worksheet or chart.
  • Customized templates which are created by the user and saved on the computer or SkyDrive.

This article is divided in 4 parts:

  1. Using and Downloading Existing Workbook Templates in Excel 2013,
  2. Creating Your Own Workbook Templates in Excel 2013,
  3. Creating and Using Worksheet Templates in Excel 2013,
  4. Creating and Using Chart Template in Excel 2013;

PART 1 – USING AND DOWNLOADING EXISTING WORKBOOK TEMPLATES IN EXCEL 2013

When you start Excel 2013 from the Start Menu in Windows, the first thing you see is the Start Screen menu which is consisted of multiple options like Info, New, Open, Save etc. 

PRINTING IN MICROSOFT EXCEL 2013 – PART 1

Microsoft Excel 2013

This article explains the most efficient procedures for printing in Excel 2013. Although for quick print you need just to press Ctrl + P key and select the Print Icon from the backstage screen, there are many tools which can be very useful for completely setting up the printing process. The article is divided in two parts. The first part covers the printing options like setting the proper printer, setting the print area, paper format, number of pages to be printed etc. You can adjust these options with few clicks on the mouse. The second part covers setting the page margins which often requires drag and drop maneuvers with the mouse. You should use the preview pane in backstage screen to see the result from these maneuvers.

PART 1 – SETTING COMMON PRINTING OPTIONS

To print workbook, worksheet or particular range of cells in Excel 2013 you have to access the Print Pane.

01 - file tab