Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Questions
First, when copying and pasting from one sheet to another it will bring the
formatting but not the size of the columns and rows. Is there a way to copy that as will without having to resize them every time? And, is there a way to put a page number footer on each page so that it will number each page in sequence? Richard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Questions
See paste special options
XL2003 Copy cell/s Select target Edit, Paste Special XL 2007 Copy cell/s. On the Home tab, in the Clipboard group, click Copy Select target. On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Paste Special. Under Paste, select you paste special option. (Hint: you can paste special one option then paste special another) ?B?UmljaGFyZA==?= wrote in : First, when copying and pasting from one sheet to another it will bring the formatting but not the size of the columns and rows. Is there a way to copy that as will without having to resize them every time? And, is there a way to put a page number footer on each page so that it will number each page in sequence? Richard -- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Questions
Oops, forgot part 2
Xl2003 View Header and Footer Click Custom footer Choose your section past this &[Page] & " of " &[Pages] XL2007 See Insert page numbers by using the Page Setup dialog box: http://office.microsoft.com/en-us/ex...100798581033#2 ?B?UmljaGFyZA==?= wrote in : First, when copying and pasting from one sheet to another it will bring the formatting but not the size of the columns and rows. Is there a way to copy that as will without having to resize them every time? And, is there a way to put a page number footer on each page so that it will number each page in sequence? Richard -- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Questions
Hi,
The technique is version dependent, but for all versions this works: If you select the entire column when you copy then the column width will be retained when you paste. Also, you add page numbering in the Header or Footer area by clicking the Page # and Number of Pages buttons and then on the Sheet tab choosing down then over or over then down to indicate the order of printing and hense numbering. In 2003 you can reach the Page Setup box by choosing File, Page Setup. In 2007 you reach it by choosing Page Layout, and then clicking the quick launch button in the bottom right corner of the Page Setup group. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Richard" wrote: First, when copying and pasting from one sheet to another it will bring the formatting but not the size of the columns and rows. Is there a way to copy that as will without having to resize them every time? And, is there a way to put a page number footer on each page so that it will number each page in sequence? Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 questions. | Excel Discussion (Misc queries) | |||
if questions | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
2 questions | Charts and Charting in Excel | |||
3 Questions actually! | Excel Discussion (Misc queries) |