I need some help in formatting data in Excel

Asked By ave broers 70 points N/A Posted on - 12/03/2014

How can I format my data in the worksheet in Excel? Is there a way to apply the same formatting to all worksheets in the workbook? How do I do this? Is it possible to eliminate certain sheets when I do this?Are there quick styles available in Excel like in MS word?

• Status: Open
• Question Views: 564
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Anthony Taft 0 points N/A #151838

I need some help in formatting data in Excel

Hi,

There are multiple ways to format your data in the worksheet depending on what you wanted to do. If you want to apply the same format to all worksheets in the workbook :



Ctrl+click the tabs of the sheets on your worksheets to group it all  together, and  the tabs will turn white.  after sheets are grouped, anything you enter  in one sheet will  also apply into the others.

About Anthony Taft

Questions
0

Answers
6

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/03/2014
• Question Category: MS Excel