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

landscape

ResolvedVersion 2003

Emily has attended:
Excel Introduction course

Landscape

When you print out a spreadsheet in Landscape it never goes across the whole page, even though I have selected A4 on page set up

RE: Landscape

Hi Emily

You might find that your margin are set too high if you are not using the full length of the page. Try this:
File
Page Setup...
Click on Margins Tab
Set to small amounts in Left and Right Fields.

Let me know if that solves it.

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

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.