|
Extract Full Address into cells
Extract four lines of us address in four rows into five cells (Name, Street, City, State and Zip)
This helped me a lot during my archiving process and I hope it will help you ...
details
|
|
Views: 274
|
|
Downloads: 52
|
|
UI: En
|
|
Since: 12/30/2008
|
|
|
Weekly Calendar
Weekly calendar (functions only, no VBA or macros) to those of you who needed that
It has three sheets, one for this week (The date of today), one for next week, and the third one is for the ...
details
|
|
Views: 361
|
|
Downloads: 79
|
|
UI: En
|
|
Since: 12/31/2008
|
|
|
Long list to short
Show two columns in one page as four columns using functions only. This will help you to show the next x number of rows for a certain column to the next of the first one to reduce the number of pages ...
details
|
|
Views: 279
|
|
Downloads: 53
|
|
UI: En
|
|
Since: 12/30/2008
|
|
|
Back Color Fast selecter
Excel2007 only
Once you enabled the macros, press ALT+c then a combination of three numbers (between 0 to 9) to change the backcolor of the selected cells into the new color
The new color ...
details
|
|
Views: 887
|
|
Downloads: 97
|
|
UI: En
|
|
Since: 12/28/2008
|
|