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

Excel

ResolvedVersion 2003

Wed 7 Apr 2010, 15:41 Delegate Nathalie said...

Nathalie has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
MOS Exam course

Excel

When I copy a report into a new excel file the grids are in the background and I cant remove them so there is a blank background?

Fri 9 Apr 2010, 17:55 Trainer Andrew said...

RE: Excel

Hi Nathalie

You can switch off gridlines in your new sheet by going to Tools > Options > View then de-selecting gridlines from the Window Options group.

Let me know if you still run into problems or if you have any other questions.

Kind regards,
Andrew

Fri 16 Apr 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Cycling through Absoulte cell references