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

borders

ResolvedVersion 2003

Fatu has attended:
Excel Introduction course

Borders

how do you create borders using the mouse to draw them

RE: borders

There is a 'Draw border' icon on the 'Borders' toolbar. When selected your cursor changes to a pencil. If you keep the right key of the mouse depressed a border will be drawn around the outside edge of the dragged area. It's like selecting a range of cells by dragging the mouse, except rather than selecting them, a border is drawn around the edge.

The 'Draw border' tool toggles with 'Draw border grid'. When the grid is selected all of the cells within the dragged area are bordered to create a table effect.

If requires, change the 'Line style' and 'Line color' from the Borders toolbar before you drag the cells, otherwise you get a basic black line.

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

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.