How can you apply the same formatting to every sheet in a workbook in ms-excel?
- 1 Answers
- 824 Views
- I also Faced
- E-Mail Answers
Answer / Nishtnt Kumar Ramteke
To apply the same formatting to every sheet in a workbook in Microsoft Excel, you can use the built-in feature called 'Format as Copy'. Here's how: 1. Format one of your sheets as desired. 2. Right-click on another sheet and select 'Format...'. 3. In the 'Format Cells' dialog box, click on the 'More Category' tab. 4. Click on 'Copy...' and then choose 'Formats'. 5. Now go back to the first formatted sheet, right-click on any cell, and select 'Paste Special > Formats'. This will apply the same formatting to the new sheet.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you count how many times a word appears in excel?
What is meaning of goal seek?
Why would you use vlookup?
What is the len function in excel?
How to split cell in excel shortcut?
How do you write a sum formula in excel?
What does #value mean in excel vlookup?
What does edit scenarios mean in excel?
How do I open an excel file?
What is conditional formatting in access?
What is financial modelling in excel?
What common problems does a collection of spreadsheets created?
MS Excel Microsoft 
