|
||||||||
|
||||||||
|
||||||||
|
|
|
User Tools
2D Graphics
- Fireworks (286)
- Flash (4167)
- Gimp (255)
- Illustrator (1476)
- Paint Shop Pro (54)
- Photoshop (16740)
3D Graphics
- 3DS MAX (2419)
- AutoCAD (84)
- Blender 3d (286)
- Bryce 3d (28)
- Cinema 4D (143)
- Lightwave 3D (38)
- Maya (571)
Web Design & Development
- Adobe Flex (66)
- ASP (378)
- ASP.NET (485)
- ColdFusion (16)
- CSS (575)
- Dreamweaver (388)
- HTML (403)
- Java (731)
- Javascript (926)
- MM Fusion (1)
- MS FrontPage (20)
- Perl and CGI (123)
- PHP (1570)
- Python (69)
- Ruby on Rails (106)
- SEO (185)
- Web Design (315)
- XML (164)
Business Applications
- MS Excel (448)
- MS PowerPoint (169)
- MS Word (154)
- QuarkXPress (8)
Business Development
- Accounting (46)
- eCommerce (77)
- Legal (7)
- Marketing (246)
Databases
Desktop Programming
- C and Cpp (518)
- Delphi (21)
- Visual Basic (339)
- Visual C (30)
Video Editing
- Final Cut Studio (23)
- Premiere (65)
Miscellaneous
- P2P Filesharing (8)
- Web Hosting (159)
Newsletter
User Login
Stats
- Tutorials: 38,110
- Categories: 572
| MS Excel Tutorials : Macros Tutorials | RSS  |
| Microsoft Excel is an application that helps you create intricate and dynamic spreadsheets. Use this robust application to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis. |
|
| JOIN OUR MS EXCEL DISCUSSION FORUM |
|
|
-
Force Text to Upper- or Proper Case
in MS Excel / Macros
2010-07-13
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only. Rating: 
Hits: 
2889 Comments: 
0 Votes: 24 Broken Link? -
Change Text to Upper- or Proper Case
in MS Excel / Macros
2010-07-13
When using a built-in Excel function is impractical, you can use a custom macro to change any existi Rating: Hits: 2522 Comments: 0 Votes: 21 Broken Link? -
Hide and Restore Toolbars in Excel
in MS Excel / Macros
2010-07-12
Attach a custom toolbar to your spreadsheet that doesn't get in the way of the end user's settings f Rating: Hits: 1631 Comments: 0 Votes: 28 Broken Link? -
Convert Formula References from Relative to Absolute
in MS Excel / Macros
2010-07-12
Change absolute formula references to relative references, vice versa, or a mix of absolute and rela Rating: Hits: 2141 Comments: 0 Votes: 32 Broken Link? -
Track and Report Changes in Excel
in MS Excel / Macros
2010-07-12
To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA an Rating: 
Hits: 2905 Comments: 0 Votes: 27 Broken Link? -
Excel Three-Criteria Limit for Conditional Formatting
in MS Excel / Macros
2010-07-10
You can use VBA to tutorial conditional formatting to use more than three criteria on your data. In Rating: Hits: 3206 Comments: 0 Votes: 32 Broken Link? -
Retrieve a Workbook Name and Path
in MS Excel / Macros
2010-07-10
Every now and then you might want a cell to return the name of a workbook, or even the workbook's fi Rating: Hits: 1449 Comments: 0 Votes: 25 Broken Link? -
Run Procedures on Protected Worksheets
in MS Excel / Macros
2010-07-10
Excel macros are a great way to save time and eliminate errors. However, sooner or later you might t Rating: Hits: 1250 Comments: 0 Votes: 34 Broken Link? -
Distribute Macros
in MS Excel / Macros
2010-07-10
Although you can distribute a macro along with a workbook, if you want to distribute only the macro' Rating: Hits: 1547 Comments: 0 Votes: 25 Broken Link? -
Automatically Add Date/Time to a Cell upon Entry
in MS Excel / Macros
2010-07-10
Enter a static date, or date and time, into a corresponding cell after data is entered into other ce Rating: Hits: 2174 Comments: 0 Votes: 40 Broken Link?
Total:
