Can't flip a spreadsheet upside down.

[bosston]

I'm helping the Nursing dept. try to print a Blue Card master
spreadsheet. They want both the inside page and outside page on the
same spreadsheet. The inside page has to be upside down on the same
sheet as the outside page so that they can fold them in half after
printing on blue paper. How do I flip the inside page upside down? I
tried selecting the spreadsheet, Format Cell and changing the alignment
but it only goes about halfway to 90 degrees.

 

[Jim]

You may hold the Shift key and Edit>Copy Picture, then Shift>Edit>Paste
picture, which can be rotated using the Drawing tool bar. The data is no
longer "live" in a picture, so you'd have to do this each time you cahnge
the schedule.

 

[Anders S]

Another way which actually keeps the data "live":

Copy the cells normally, the do Shift+Edit>Paste picture link.
You will get a picture that can be rotated, resized and placed in any way you like. The data in the picture will still be linked to the source cells.

HTH
Anders Silvén

You may hold the Shift key and Edit>Copy Picture, then Shift>Edit>Paste
picture, which can be rotated using the Drawing tool bar. The data is no
longer "live" in a picture, so you'd have to do this each time you cahnge
the schedule.

 

[bosston]

Thanks to both that responded. Either one of the options both worked.

 

[Lady Layla]

Don't think this can be done from within Excel

Check your printer properties and see if your printer supports different
direction printing

If not, print out as normal, go to copier, tape spreadsheets together as you
need, copy onto plain sheet to verify correctness and then run on blue paper

(Or send to printing shop)

:
: I'm helping the Nursing dept. try to print a Blue Card master
: spreadsheet. They want both the inside page and outside page on the
: same spreadsheet. The inside page has to be upside down on the same
: sheet as the outside page so that they can fold them in half after
: printing on blue paper. How do I flip the inside page upside down? I
: tried selecting the spreadsheet, Format Cell and changing the alignment
: but it only goes about halfway to 90 degrees.
:
:
: ------------------------------------------------
:
:
:

 

[Louis]

I tried the image-pasting tip in Office 2000 and while the image was
there and properly linked, it wouldn't rotate it. Any advice would be
greatly appreciated.

(For the curious ones, in my case its for a flight planning sheet)

 

[Anders S]

Not 100% sure, but I think rotation was introduced in Excel 2002. Can't check with Excel 2000, but in Excel 97 Paste Picture Link is available, but the pictures can't be rotated.

Anders Silvén