Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel consultant - formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Formatting

excel consultant - Formatting

ResolvedVersion Standard

Akhmad has attended:
Excel Introduction course

Formatting

How to format non-adjacent cells in one go?

RE: Formatting

You can select non-adjacent cells by using the CTRL key. Once you have selected the cells, then chooce FORMAT > CELLS from the menu bar.

RE: Formatting

You can select non-adjacent cells by using the CTRL key. Once you have selected the cells, then chooce FORMAT > CELLS from the menu bar.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.