microsoft excel - printing

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel - Printing

microsoft excel - Printing

resolvedResolved · Low Priority · Version Standard

Laura has attended:
PowerPoint Introduction course
Excel Introduction course

Printing

how do I print a spreadsheet on one page of a4 or make sure that it isnt split out across several pages?

RE: printing

select the print area by highlighting it and then going file > print area > set print area.

then you need to go file > page setup... and select the 'fits into 1 page wide by 1 page tall bit about halfway down the dialogue box.


 

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Server loaded in 0.09 secs.