Hi all,
Hoping this is a quick fix. I've searched for an answer to this on the site and others but to no avail. It's not a big issue but I was wondering is there a key board shortcut for double clicking the "format painter" icon in Excel?
I know Alt+HFP gets is the keyboard shortcut for clicking once on the icon but I'd like to know if there is one to double click it?
Appreciate if anyone knows the answer to this.
thanks in advance.
Cathal
I'd prefer this..
- Copy
- Paste special -- formats
F4 to repeat on other ranges
Life's a spreadsheet, Excel!
Say thanks, Click *
Just do copy using Ctrl+C and while pasting just paste the FORMAT alone by pressing Alt+E+S+T.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks Ace_XL and Sixsence. Both answers work. Thanks for getting back to me so quickly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks