G
Guest
How do I rotate a Excel doc 180 degrees?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
You mean when you print it?
File|Page setup|Page tab
check Landscape (or portrait)--check the one that isn't checked.
File|Page setup|Page tab
check Landscape (or portrait)--check the one that isn't checked.
D
Dave Peterson
ps. That only rotates it 90 degrees, though.
How do I rotate a Excel doc 180 degrees?
S
swatsp0p
couldn't you just turn the page upside down
I had this reply to a related thread about rotating a table in Excel 180 degrees:
I worked on this for some time on Excel 2011 for Mac and would like to update this method for rotating a data table 180 degrees. The formula is more like what I have below, where "original_table_bottom_right" and "new_table_top_left" are self explanatory references to the bottom right cell of the original table or the top left cell of the new table which has been rotated 180 degrees, respectively.
You can define the names for these two cells or you can reference these two cells directly in the formula, but if you reference the cells directly in the formula they need to be absolutely referenced with the style "$A$1".
=OFFSET(original_table_bottom_right,ROW(new_table_top_left)-ROW(),COLUMN(new_table_top_left)-COLUMN())
I worked on this for some time on Excel 2011 for Mac and would like to update this method for rotating a data table 180 degrees. The formula is more like what I have below, where "original_table_bottom_right" and "new_table_top_left" are self explanatory references to the bottom right cell of the original table or the top left cell of the new table which has been rotated 180 degrees, respectively.
You can define the names for these two cells or you can reference these two cells directly in the formula, but if you reference the cells directly in the formula they need to be absolutely referenced with the style "$A$1".
=OFFSET(original_table_bottom_right,ROW(new_table_top_left)-ROW(),COLUMN(new_table_top_left)-COLUMN())