Excel guru's

[rich 36]

Quick one,
what keyboard shortcuts are available
for cell formatting,

I'm thinking in terms of say,

alingnement/bold

cheers Richard

[esselte]

Ctrl+b will put text into bold (and also take bold off)

[rich 36]

Hi esselte how are ya'

Ctrl B & S are the actual one i know,

think i've read all the famous articles on shortcuts

was wondering if you lot want to share your faves

[esselte]

I'm fine thanks keeping busy,yourself? I usually just use the buttons on the toolbar wih excel,it seems just as easy as using shortcuts.See you

[Raify]

this is a good list: http://office.microsoft.com/en-us/ass

[rich 36]

cheers, not seen that one.

I'll have a browse in the morning

[hornet]

Alt + O will take you to the formatting menu if you don't want to mouse click.

Quick ones I use a lot are CTRL + C to copy and CTRL + V to paste, as well as Alt+E for the edit/paste special option. Good ones for navigating round a spreadsheet are END + HOME, which takes you to the bottom right of a range (and the reverse CTRL + HOME).

I seldom use the mouse for navigating and formatting now, as I find the keyboard shortcuts much, much quicker.

[Platinum]

Ctrl + I : Italic
Ctrl + X : Cut

hornet said:

I seldom use the mouse for navigating and formatting now, as I find the keyboard shortcuts much, much quicker.

F2 is a good one; to edit cell contents, especially if you have a huge formula/lots of text.

Edited by Platinum on Monday 30th October 23:26

[road2ruin]

Try ctrl+Alt+Delete a few times, thats always good for a laugh. Seems to clear the screen, of everything.

[dougc]

I use CTRL+1 quite a bit to get to the Cell Format options - changing from text to number, aligning text, merging, that sort of stuff.