I am working spreadsheet that needs to print to fit existing forms. I have figured out the height of each row for a page so everything ends up in the right place. Is there a way to duplicate those various heights for the rest of the pages?
I am working spreadsheet that needs to print to fit existing forms. I have figured out the height of each row for a page so everything ends up in the right place. Is there a way to duplicate those various heights for the rest of the pages?
"Laugh? I thought I'd die!"
Jimbo?
Format painter?
Last edited by Sam Capricci; 05-23-2014 at 06:11 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
If you click on a cell in the 1st worksheet, then click onteh tab of the last worksheet, this will "group" all your sheets.
Now, whatever you do to 1 sheet, will get done to all the sheets...if you adjust the height of row 2, all row 2's get adjusted. If you enter in A1 =B1, then that will be entered in all A1's etc
When done, right-click a tab and select Ungroup
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FDibbins - that's a good trick. I had no idea.
Sambokid - I don't know what format painter is. I will see what I can find about it.
Format painter is the little paint brush on the Home tab in the left corner. you click a cell (or range) containing the format you want to copy, click the format painter, then click the cell (or range) that you want to copy the format to - really cool
Best. Lesson. Ever!!!!
Happy to help and thanks for the feedback![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks