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

worksheet andor table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » worksheet and/or table formatting

worksheet and/or table formatting

ResolvedVersion 2007

Fawzia has attended:
Excel Advanced course

worksheet and/or table formatting

is it possible to set up different row widths within a table or worksheet?

RE: worksheet and/or table formatting

Hi Fawzia

Thank you for your question; and welcome to the forum.

You can change the height of rows by doing the following:

Select the group of rows that you wish to change the height of. Right-click within the selected area, choose Row Height, enter the height (e.g. 15) and click OK or press Enter.

I hope this helps.
Amanda

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

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.21 secs.