ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Sheet names and formatting Q (https://www.excelbanter.com/new-users-excel/445825-sheet-names-formatting-q.html)

dilexcel April 19th 12 07:07 PM

Sheet names and formatting Q
 
I only have basic skills in excel and am currently trying to find a new way to improve an exsiting excel file. It is a file that needs to be updated often and I seem to be having to edit the formatting every time.

I want to know if it is possible to have each page automatically default to a new sheet and have the sheet named Page 1 for page 1, page 2 for page 2 etc.

I have made a template of the main formatting I want for each sheet and I want it to stay the same for each sheet and not be able to be modified as I add data.

I apologise I am not very skilled in this area and struggle with formulas and have not used a forum before.

Please let mw know if you have any suggestions.

Much appreciated.


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com