| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Big background page numbers/ Can't change format of a range
Hello,
I received a spreadsheet used for printing out tables of data. This spreadsheet contains two features which I would like to understand: 1) Each Excel range that is printed on a separate page contains a big page number in the background of the speadsheet: "page1", "page2" etc. This page number, however, is not printed. How is this achieved? 2) There is a gray are outside the actual data range - and I can't change the formatting of that area. The spreadsheet is not protected. Thank you Michael |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Big background page numbers/ Can't change format of a range
You're in "Page Break Preview".
Click <View <Normal -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Micky01" wrote in message ... Hello, I received a spreadsheet used for printing out tables of data. This spreadsheet contains two features which I would like to understand: 1) Each Excel range that is printed on a separate page contains a big page number in the background of the speadsheet: "page1", "page2" etc. This page number, however, is not printed. How is this achieved? 2) There is a gray are outside the actual data range - and I can't change the formatting of that area. The spreadsheet is not protected. Thank you Michael |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Big background page numbers/ Can't change format of a range
Thank you very much for the fast reply
Michael "Ragdyer" wrote in message ... You're in "Page Break Preview". Click <View <Normal -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Micky01" wrote in message ... Hello, I received a spreadsheet used for printing out tables of data. This spreadsheet contains two features which I would like to understand: 1) Each Excel range that is printed on a separate page contains a big page number in the background of the speadsheet: "page1", "page2" etc. This page number, however, is not printed. How is this achieved? 2) There is a gray are outside the actual data range - and I can't change the formatting of that area. The spreadsheet is not protected. Thank you Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
| Format page numbering to be Page 1 of X | Excel Discussion (Misc queries) | |||
| How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
| How to change default cell format to "Text" | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Linear Mode
