Tips & Tricks

Hi,

Below is the list of posts under Tips & Tricks label.

• Enable Developer Tab
• Show All Formulas Used
• Get Rid of Update Links Alert
• Hide Formulas & Contents of Cells in Formula Bar
• Hide Content of Cells
• Do Basic Math by Paste Special
• Few Little Known Paste Commands
• Work With Visible Cells Only
• Fill Blank Cells With Non-Blank Cells Above
• Resize Scrollbars
• Avoid Automatic Hyperlinks
• Enter Text over Multiple Lines
• Combine Text and Formula in one Cell
• Format Numbers to Display Thousands
• Excel Speech Command
• Debug Formulas in Formula Bar
• Toggle ScreenTips
• Toggle Mini Toolbar
• Change Default Colour Scheme
• Insert Background Picture in Comments
• Convert Text Formatted as Numbers to Numbers
• Change Default File Format
• Always Open a Specific Excel File
• Use Alternative Startup Folder
• Change Comment's Default Formatting
• Very Hide a Sheet
• Change Default Saving Location
• Easy Navigation through Sheets
• Apply Page Setup to Multiple Sheets
• Change Default Number of Sheets
• Expand Shorthands (AutoCorrect)
• Use Custom Number Formats Across Workbooks
• Toggle Live Preview
• Control Cursor Movement on Pressing Enter
• Unhide All Hidden Sheets
• Change Default User Name
• Change Default Font & Size
• The ClearType Font