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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel learn london - Formatting Cell range

excel learn london - Formatting Cell range

ResolvedVersion Standard

Thu 10 Jan 2008, 16:09 Delegate Dipesh said...

Dipesh has attended:
Excel VBA Intro Intermediate course

Formatting Cell range

How can I create a marco to format a range of cells, but with varying formats. E.g The headers are formated with a blue fill and white font, and the body of the range white fill with black font and borders?

Thu 10 Jan 2008, 16:43 Delegate Paul said...

RE: Formatting Cell range

Tools > Macros > record new macro

then do the formatting.

then press stop

then attach the macro to a button

then whenever you want to format the cells in this way, press the button

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel learn london - Formatting Cell range

Formatting Cell range

RE: Formatting Cell range

Excel articles

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010