excel courses - format

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Format

excel courses - Format

resolvedResolved · Low Priority · Version Standard

Eric has attended:
Excel Intermediate course

Format

How to highlight columns + rows in one go?

RE: Format

Hi Eric

Thanks for your question.

You can highlight multiple ranges by using the Ctrl key, for example, if you click over column B to select it, then hold down the Ctrl key and click to the left of row 6 to select it, you should find that both column B and row 6 will be selected.

If you wish to select the whole spreadsheet, use Ctrl + A.

Amanda

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips


Server loaded in 0.09 secs.