View Full Version : Sharing: What VBAx Is All About- Give It Up & Smile
YellowLabPro
09-07-2007, 03:15 AM
Share your favourite obscure tips here.
F5 Key:
You want to read that last updated post to your thread before calling it a night, and the batteries in your mouse die. Blimey--- F5 it.
F5 refreshes your web-browser window.
Ps(does this count as a KB article?) :rotlaugh:
My f5 key is worn blank thanks to various forums and the BBC cricket commentary! :)
1. If you're messing around in Excel and you freeze the app completely, Ctrl+Shift+Esc brings up the task manager on the processes tab, so you can kill it!
2. Alt + ; selects only the visible cells in a selection.
Bob Phillips
09-10-2007, 01:07 AM
Has to be double-click the format painter for me, you can then go and copy-format many other cells in separate actions, such as non-contiguous cells.
TheAntiGates
09-10-2007, 01:54 PM
Those are all indeed worthy.
A1:A399 are all nonempty. You have a formula in B1. Double click B1's lower-right fill handle. :clap:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.