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 learn london - formatting cell range

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

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?

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

Server loaded in 0.1 secs.