| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert auto text
how do you insert page 1 of 2 in a footer in excel like you can in word
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert auto text
File, Page Setup, Header/Footer, Custom Footer, click the buttons
Linda wrote: how do you insert page 1 of 2 in a footer in excel like you can in word |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert auto text
Click FILE in the menu and select PAGE SETUP. In the PAGE SETUP dialog box,
click the HEADER/FOOTER tab and then click the CUSTOM FOOTER command button. In either the left/center/right panel type the word "Page" w/o quotes, press the space bar and click the second command button (going from left to right), which has a single "+" on it. Then press the spacebar and type the word "of" followed by a space and then click the third command button (going from left to right), which has 2 plus signs on it. Your footer will look like the text below: Page &[Page] of &[Pages] -- Kevin Backmann "Linda" wrote: how do you insert page 1 of 2 in a footer in excel like you can in word |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert auto text
ViewHeader and Footer
Click on the dropdown in Footer and select Page 1 of ? Gord Dibben MS Excel MVP On Thu, 24 Jan 2008 10:13:02 -0800, Linda wrote: how do you insert page 1 of 2 in a footer in excel like you can in word |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert auto text
Kevin
Why go to Custom Footer when the default footer dropodown will suffice? Gord On Thu, 24 Jan 2008 10:51:02 -0800, Kevin B wrote: Click FILE in the menu and select PAGE SETUP. In the PAGE SETUP dialog box, click the HEADER/FOOTER tab and then click the CUSTOM FOOTER command button. In either the left/center/right panel type the word "Page" w/o quotes, press the space bar and click the second command button (going from left to right), which has a single "+" on it. Then press the spacebar and type the word "of" followed by a space and then click the third command button (going from left to right), which has 2 plus signs on it. Your footer will look like the text below: Page &[Page] of &[Pages] |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert auto text
You got me on that one Gord. It was one of my "Ready, fire, aim..." moments.
Thanks for the heads up, it helps me maintain some humility. -- Kevin Backmann "Gord Dibben" wrote: Kevin Why go to Custom Footer when the default footer dropodown will suffice? Gord On Thu, 24 Jan 2008 10:51:02 -0800, Kevin B wrote: Click FILE in the menu and select PAGE SETUP. In the PAGE SETUP dialog box, click the HEADER/FOOTER tab and then click the CUSTOM FOOTER command button. In either the left/center/right panel type the word "Page" w/o quotes, press the space bar and click the second command button (going from left to right), which has a single "+" on it. Then press the spacebar and type the word "of" followed by a space and then click the third command button (going from left to right), which has 2 plus signs on it. Your footer will look like the text below: Page &[Page] of &[Pages] |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert auto text
We all get used to replying with the Custom footer because most people already
know how to pick from the defaults so we tend to forget they are available. Gord On Thu, 24 Jan 2008 14:56:53 -0800, Kevin B wrote: You got me on that one Gord. It was one of my "Ready, fire, aim..." moments. Thanks for the heads up, it helps me maintain some humility. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto insert row: | Excel Worksheet Functions | |||
| Auto Text Insert of Footer Information | Excel Discussion (Misc queries) | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| Auto Insert/Auto Formula? | Excel Worksheet Functions | |||
| auto row insert | Excel Worksheet Functions | |||
Linear Mode
