Excel FAQ
A collection of the most frequently asked questions in the Excel/VBA forum. Check in Here Before Posting
-
-
-
Automatically Add Date and/or Time
- Dave Hawley
August 15, 2005 at 10:23 AM
- Dave Hawley
August 15, 2005 at 10:23 AM
-
- Replies
- 0
- Views
- 5k
-
-
-
-
Conditional Formatting
- Dave Hawley
June 15, 2005 at 8:37 AM
- Dave Hawley
June 15, 2005 at 8:37 AM
-
- Replies
- 0
- Views
- 5k
-
-
-
-
TrackChanges
- Dave Hawley
November 2, 2005 at 6:26 AM
- Dave Hawley
November 2, 2005 at 6:26 AM
-
- Replies
- 0
- Views
- 4.9k
-
-
-
-
Value of year changes to the current year when opening a csv file created in Excel 1
- The Dutchman
February 25, 2016 at 4:10 PM
- The Dutchman
February 25, 2016 at 4:12 PM
-
- Replies
- 1
- Views
- 4.8k
1
-
-
-
-
Filter ListBox Data
- Dave Hawley
August 12, 2005 at 3:10 AM
- Dave Hawley
August 12, 2005 at 3:10 AM
-
- Replies
- 0
- Views
- 4.8k
-
-
-
-
Count Words in a Cell or Range of Cells
- Dave Hawley
June 30, 2005 at 5:30 AM
- Dave Hawley
June 30, 2005 at 5:30 AM
-
- Replies
- 0
- Views
- 4.7k
-
-
-
-
Sort/Sorting Sheets/Worksheets
- Dave Hawley
September 13, 2005 at 10:20 AM
- Dave Hawley
September 13, 2005 at 10:20 AM
-
- Replies
- 0
- Views
- 4.7k
-
-
-
-
Validating UserForm TextBox to Only Accept Numbers
- Dave Hawley
June 30, 2005 at 5:33 AM
- Dave Hawley
June 30, 2005 at 5:33 AM
-
- Replies
- 0
- Views
- 4.7k
-
-
-
-
Send Email
- Dave Hawley
October 5, 2005 at 3:40 AM
- Dave Hawley
October 5, 2005 at 3:40 AM
-
- Replies
- 0
- Views
- 4.6k
-
-
-
-
Consolidate
- Dave Hawley
August 3, 2005 at 7:57 AM
- Dave Hawley
August 3, 2005 at 7:57 AM
-
- Replies
- 0
- Views
- 4.6k
-
-
-
-
Convert Formula References
- Dave Hawley
June 25, 2005 at 12:18 AM
- Dave Hawley
June 25, 2005 at 12:18 AM
-
- Replies
- 0
- Views
- 4.6k
-
-
-
-
Alternate Row Coloring
- Dave Hawley
June 24, 2005 at 9:44 AM
- Dave Hawley
June 24, 2005 at 9:44 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
Mask Date Entries
- Dave Hawley
October 14, 2005 at 5:02 AM
- Dave Hawley
October 14, 2005 at 5:02 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
Dependent Validation Lists
- Dave Hawley
October 13, 2005 at 9:22 AM
- Dave Hawley
October 13, 2005 at 9:22 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
Data Validation
- Dave Hawley
June 22, 2005 at 8:57 AM
- Dave Hawley
June 22, 2005 at 8:57 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
Prevent UserForm Closing to Top Right X
- Dave Hawley
July 28, 2005 at 7:13 AM
- Dave Hawley
July 28, 2005 at 7:13 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
Count of Each Item in a List
- Dave Hawley
June 26, 2005 at 7:25 AM
- Dave Hawley
June 26, 2005 at 7:25 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
AutoFilters
- Dave Hawley
July 26, 2005 at 9:15 AM
- Dave Hawley
July 26, 2005 at 9:15 AM
-
- Replies
- 0
- Views
- 4.4k
-
-
-
-
Increase/Decrease Values permanently
- Dave Hawley
October 13, 2005 at 4:18 AM
- Dave Hawley
October 13, 2005 at 4:18 AM
-
- Replies
- 0
- Views
- 4.4k
-
-
-
-
Save a Workbook as the Text in a Cell
- Dave Hawley
June 28, 2005 at 9:03 AM
- Dave Hawley
June 28, 2005 at 9:03 AM
-
- Replies
- 0
- Views
- 4.4k
-