Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Formatting cells
Resolved · Low Priority · Version Standard
Tess has attended:
Excel Intermediate course
How do I copy the format of one cell to another?
Tess
The quickest way to do this is to select the cell being copied. Then
Click the [b]Format Painter[/B] icon on the toolbar (next to the paste icon)
Click on the cell to be formatted
The cell takes up the format of the original cell
Hope this helps
Carlos
|
Excel tip:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |
We'll call during UK business hours
Server loaded in 0.07 secs.