Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Linda has attended:
Excel Intermediate course
Excel Advanced course

Excel

Print all Pivot Table Sheets in workbork at once

RE: Excel

Hi Linda

Thank you for your question.

If there are specific sheets that you wish to print from an Excel file, then you can bring up the first sheet you wish to print; then hold down the Ctrl key on your keyboard and click on the tabs of the other sheets that you wish to print.

Then click the Print button. This will print just the selected sheets.

Afterwards, right-click on the tab of the top sheet and select Ungroup Sheets.

I hope this helps.
Amanda

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.