format

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Format

resolvedResolved · Low Priority · Version 2003

Darren has attended:
Excel Intermediate course
Excel Advanced course

Format

How do i auto adjust all cells?

RE: Format

Hi Darren,

To auto adjust all cells:

1> Press CTRL A to select all cells.

2> Double click the line between column A & B to adjust the columns.

3> Double click the line between rows 1 & 2 to adjust the rows.


Regards,


Ben


 

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips


Server loaded in 0.09 secs.