web analytics

Tag Archives: Microsoft Office 2013

INSERT HEADERS OR FOOTERS INTO MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article will show you how to insert headers and footers into Microsoft Excel 2013. Headers and footer are standard texts that appear on every page of the report. The header is in the top margin of the page and footer is in the bottom margin. Both are centered vertically in the margins and unless you specify otherwise Excel does not automatically add either to a new workbook.

To add a header or footer to your report you go to page layout view by clicking the button on the status bar, then position the mouse pointer over the section in the top margin of the first page marked click to add header or in the bottom margin of the first page marked click to add footer.

1

HOW TO AUTOMATE COMMANDS IN MICROSOFT EXCEL 2013 WITH MACROS – PART 2

Microsoft Excel 2013

This is a continuation of PART 1 of this article.

For this example macro, select the personal macro workbook so that you can use it to enter the company name in the any excel workbook that you create or edit. Click on the OK button in order to close the record macro dialog box. Select the cells, enter the data and choose the Excel commands required to perform the tasks that you want. Recorded just as you normally would in creating or editing the current worksheet, using the keyboard, the mouse or a combination of the two. After you are finished recording, just click on the Stop Recording button located in the status bar or the Developer Tab on the ribbon.

To run a recorded macro just click on the View Macros option located on the macros buttons drop-down menu on the View tab or you can just press Alt+F8 in order to open the macro dialog box.

1

HOW TO REORDER THE LAYER OF GRAPHIC OBJECTS IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article will teach you how to reorder the layer of graphic objects in Microsoft Excel 2013. When graphic objects overlap each other you can change other displayed by sending the objects backward or forward so that they reside on different layers. Excel 2013 let’s you move the selected graphic object to a new layer in one of two ways. To move the selected object up to or to the top layer, select the bring forward or bring to front option on the bring forward buttons drop-down menu in the arrange group, in a drawing, pictures or smart card tools contextual tab.

1

HOW TO GROUP IMAGES IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article is about grouping images in a Microsoft Excel 2013 worksheet. Usually in Microsoft Excel there are situations that require to group different graphic objects in order to have them act as one in order to be able to move all the objects with one move instead of having it to do it several times in a row.

If you want to group several different objects, just hold the Ctrl button and then click each of the objects that you want to group into one. After you have done this, just click on the Group Objects button located in the Arrange Group on the Format tab under the appropriate tools and after that just click the Group button on its drop-down menu.

1

USE TEXT TO SPEECH TO FIND ERRORS IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article will show you how to use text to speech in order to find errors in a Microsoft Excel 2013 worksheet. The text-to-speech feature lets your computer read aloud any series of cell entries in the worksheet. It’s great for checking your printed source while the computer reads.

To start click the customize quick access toolbar button at the end of the toolbar, followed by more commands on the drop down menu.

1