excel word powerpoint courses london - microsoft exel formula

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - Microsoft Exel formula

excel word powerpoint courses london - Microsoft Exel formula

resolvedResolved · Low Priority · Version Standard

Microsoft Exel formula

How do you insert columns

RE: Microsoft Exel formula

Rajeev,

I find the easiest way to insert columns is to right click a column header and choose Insert. This inserts a column before the one you right clicked. To insert more than one, you would select x amount of columns, and do the same thing. this will insert the number of columns you selected.

Another way is to go to Insert -> Column using menus. Of course you use the ribbon if you've got Microsoft Office Excel 2007.

Keep up the great work!

Regards, Rich


 

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.1 secs.