jump to navigation

Paste Special 2007.10.17

Posted by jcohen22 in XL tips.
Tags:
add a comment

This is one of those simple things that most of y’all know, but I thought I’d mention it in case you didn’t. Once something is copied (edit->copy, or ctrl+c, or the copy button), you can paste it as usual (edit->paste, or ctrl+v, or the paste button). But I propose an alternative.

(more…)

Fx Button, Insert function, Function Arguments 2007.08.30

Posted by jcohen22 in Troubleshooting.
add a comment

Have you ever wondered what the fx button is for? I’m talking about the little itty bitty button directly to the left of the editable area in the formula bar. Do you know it? Is it your friend? It’s mine. Let me introduce y’all.

This handy button is a quick resource for finding functions in Excel that you just can’t remember or don’t know exist.  (more…)

Help Files 2007.08.22

Posted by jcohen22 in Troubleshooting.
add a comment

Even a guru like me needs a little help from my friends. And when that doesn’t work, (or even before I ask friends) I turn to my trusty Excel help files.

The F1 key on your keyboard is the shortcut. You can access help using an untold number of methods. Some common methods include the help menu, the F1 key, and the help button in dialog buttons.

(more…)

On keyboarding and toolbar customization 2007.08.20

Posted by jcohen22 in Toolbars.
4 comments

An optimally customized toolbar is essential for efficient excel work. Now, I know what you’re thinking.

  • I can find everything I need in the menus.
  • Or, I rarely use a mouse – I’m a keyboard shortcut person.

Regarding the first thought – You’re wrong. Yeah, you think you’re right – but you’re wrong. The menus do contain many many functions and tools. I don’t believe all buttons are accessible from the menus. (more…)