Share this content

The ExcelZone Compendium Archive 1999-2007

23rd Aug 2007
Share this content
Kashflow logo

  • Top 20 Excel tips from Chris Bales (2000)
  • Gail Perry's Excel Almanac - Top Productivity Tips
  • Excel navigation tips from AccountingWEB members
  • Excel spreadsheets in budgeting Peter Wolstenholme's horror story
  • Spreadsheet errors and how to avoid them by Ray Butler, Customs & Excise
  • Build your own Excel Net to Gross function Simon Hurst tutorial
  • Data validation for better spreadsheets
  • An introduction to Excel-driven reporting tools
  • Want to learn about Excel pivot tables? Start here
  • Improve your reporting skills with self-teach tutorials
  • David Carter's two-minute Excel tips
  • David Carter's five-minute pivot table tips
  • Excel templates - buried treasure on Microsoft.com
  • ExcelZone links
  • Excel Compendium - 2007 update - shorter version pointing more to tutorial/digest articles
  • Back to Index

  • Top tips on Excel from Chris Bales (online workshop)
  • New supply of Excel tips from AccountingWEB
  • Gail Perry's Excel Almanac - Top Productivity Tips
  • Links to Excel resources online
  • Excel Training
  • Free Excel ProductivITy tips from Simon Hurst
  • More ProductivITy Tips from Simon Hurst
  • Does anyone use ASAP Utilities for Excel?
  • What's the most useful tip/shortcut?
  • Navigation tips from AccountingWEB members
  • Does anyone use ASAP Utilities for Excel?
  • Book for Excel
  • Excel advice sites?
  • Excel templates - buried treasure on Microsoft.com
  • Excel web services tutorials on MSDN
  • Back to Index

  • ExcelZone Compendium: data entry basics
  • ExcelZone Compendium: Advanced data entry tips
  • Tell Bill Gates to fix Excel bug, urges 'Pivot King'
  • Excel Tip: Copy an entire worksheet
  • Excel Tip: Perform fast calculations
  • How to copy paste negative numbers of a different format
  • Excel - inconsistent conversion of values
  • A 'Tick' in Microsoft Excel 2000
  • Can I Transfer Excel Autocorrect entries ?
  • Text to formula in Excel
  • Horizontal Subtotal in Excel
  • Excel - Comment boxes
  • Empty space in Excel spreadsheets
  • Excel Comments
  • Another Excel query
  • Automating Excel Screen Size
  • Conversion of spreadsheets into another currency
  • Excel 97 recalculation failure
  • Remotely locating a Data Validation Criteria
  • Cursor Movements in Excel
  • Excel copy and paste question
  • Excel question - text
  • Excel column widths
  • Excel again
  • Cell display formula
  • Removing line returns (Alt+Enter) in Excel cells
  • Excel, forms and check boxes
  • Incrementing numbers in Excel
  • Ticking cells
  • Increase columns on spreadsheet
  • Increasing font size in an Excel Drop Down Box
  • Keyboard "OK" in Excel
  • Entering dates with Autofill
  • Excel Fill handle
  • Copy cell above
  • Template tracking wizard
  • Exporting Sage Transaction Types
  • Transpose
  • Date validation
  • Rows to columns
  • Keyboard shortcut to copy a figure to the cell below
  • How do you enter the worksheet tab name into a cell?
  • Remove Reviewing toolbar
  • Inserting data within Excel text
  • Lost the data entry at top of sheet
  • Back to Index

  • ExcelZone Compendium: Navigation tips & shortcuts
  • ExcelZone: Navigation tips from AccountingWEB members
  • 'Be prepared to be amazed' - Microsoft's Excel tips
  • Microsoft Office Online keyboard shortcuts
  • Microsoft Office Online - Excel shortcut and function keys
  • Charlie's List, or "214 Keyboard Shortcuts" Unofficial Microsoft listing with Excel 2007 shortcuts
  • Shortcut Keys in Excel 2000 - Maintained by David McRitchie
  • What's the most useful tip/shortcut?
  • Everybody knows about F2 in Excel
  • Back to Index

  • ExcelZone Compendium: Formatting digest
  • Format: Cell in Excel
  • Formatting in Excel
  • Excel: colour coding tabs
  • Colouring cells in an Excel spreadsheet dependent on a condition
  • Cell formatting in Excel
  • Deadline date condition change
  • White lines
  • Conditional Formatting
  • Excel - Format a cell different colours
  • Conditional Formatting
  • Conditional formatting
  • Formula for formatting
  • Format Comment box
  • Excel text to numbers (format?)
  • Convert numbers into words
  • Centre text
  • P&L in Excel - how do I suppress current month?
  • How to merge names split between two columns in Excel?
  • Merging columns using CONCATENATE in Excel
  • Excel - suppress columns
  • Conditional formatting question
  • Excel Check Boxes in Questionaires
  • Back to Index

  • ExcelZone Compendium: Dates & numbers digest
  • Excel Tip: Dealing With Rounding Errors
  • Excel - Formatting dates
  • Microsoft Excel
  • Rounding in Excel 97
  • Aligning figures in Excel
  • Displaying zeros in Excel
  • Negative numbers in Excel
  • Brackets around negative numbers in excel
  • Converting times into decimal numbers
  • Numbers in Excel forms
  • Display negatives in brackets using Excel 2002
  • English date format in Excel (Windows XP)
  • Hours & minutes in Excel
  • European Number format
  • Displaying zero as minus
  • Time format on Excel
  • Excel month & year formula
  • Negative Figures in Excel
  • More Excel and dates...
  • Adding time in Excel
  • Excel - Rounding up or down numbers to the nearest 10
  • Time values in Excel
  • Error messages when entering debits and credits
  • Negative numbers
  • Negative number formats
  • Negative in brackets
  • Formatting percentages
  • Negative number formats
  • Time measurement
  • Conversion of array of positive numbers to negatives
  • Rounding in Excel
  • Date in Excel
  • Back to Index

  • ExcelZone Compendium - sorting & filtering tips
  • Excel sequence check
  • Finding duplicate records in lists in Excel
  • Can Excel Do This?
  • Codes
  • Sorting in Excel
  • Excel Autofilter advice needed...
  • Removing duplicate records from Excel worksheets
  • Sort a list and removing duplicates in Excel
  • Splitting cells
  • Expert Guide to splitting cells in Excel
  • Sorting an Excel spreadsheet
  • How to filter data from left to right in Excel?
  • Joining two columns in Excel
  • Data Sort in protected worksheets
  • Finding non zero values in Excel
  • Excel List Selection
  • Matching two pieces of data
  • Is there an Excel function for "Contains"
  • Counting number of companies in a database
  • Find a row number in a sorted list
  • Auto filter option disappeared
  • Filtering tips
  • Removing duplicate entries in an Excel list
  • Excel Sort Query using images
  • Sort rows by colour?
  • Sort worksheets by tabs
  • Column splitting
  • Count Xs in a column
  • Autofilter totalling
  • Finding duplicate entries in Excel
  • Identifing variables between higher & lower values
  • Back to Index

  • ExcelZone Compendium: Charts & graphs
  • Excel tutorial - Charting business performance
  • Excel stacked bar charts using 2 axes
  • Excel breakeven graph
  • Excel graph - is this possible?
  • Help with a line graph in Excel
  • Excel charts
  • Graphing a summary of daily statistics
  • Excel y-axis categories
  • Charting & graphing
  • Pie Charts
  • Excel and graphical charts
  • Plotting customers on a map
  • Back to Index

  • ExcelZone Compendium - printing tips
  • How to put "&" in header/footer of Excel sheet
  • Showing comments on screen and printing
  • Print suppression in Excel
  • Excel - how do you print a watermark?
  • Excel won't print landscape
  • Excel - Page Setup - Custom footer
  • Printing multiple columns
  • Setting footnotes on all sheets
  • Template settings
  • Page footer sub totals
  • Print Settings
  • Print a spreadsheet on a different printer
  • Excel - headers and footers
  • Print alternate pages
  • Paper size
  • Headers and footers
  • Envelope printing in Excel
  • Set print area in Excel 2003
  • Back to Index

  • Excel Compendium digest - worksheets and ranges
  • Why does Excel change links to files?
  • Managing 3D spreadsheets
  • File combine facilities: Excel v Lotus
  • 10 Quick Range Name Tricks
  • An obsession with spreadsheets?
  • Can you "synchronise" two sheets?
  • How can one remove redundant links from Excel
  • Sorting Excel Sheets alphabetically
  • Excel linked files
  • Copying links from worksheet cells to a master
  • Linked, changeable Range in a formula
  • Excel Range
  • Excel & linked spreadsheets
  • Deleting automatic links
  • Summarising multiple workbooks
  • Links problem
  • Finding links in a spreadsheet
  • 'File not found' - Have you been there?
  • Combining lots of spreadsheets into one
  • Past link problems
  • Find link error message
  • How to delete Excel workbook links
  • Breaking up a spreadsheet
  • Excel destination key
  • Excel data transfers in worksheets
  • Named ranges in Excel workbook
  • Data Analysis in Excel
  • Copy worksheets to another
  • Synchronise Windows
  • Removing links
  • Combine worksheets
  • Worksheet tabs
  • Ccalculations (auto F9 in Excel XP)
  • Worksheet closes when I open another one
  • How do I get rid of this blue line around my worksheet?
  • How to combine three worksheets into one for a pivot table
  • Revise ranges in Excel
  • Back to Index

  • Want to learn about Excel pivot tables? Start here
  • David Carter's Five Minute Pivot Table Tips
  • Budgeting with Pivot tables (Excel 5/97)
  • Budgeting with Pivot Tables - Tutorial 2 (Excel 5/97)
  • Analyse sales data with Excel pivot tables
  • Sage Line 50 and Pivot Tables tutorial
  • Audit and financial reporting with pivot tables tutorial
  • Modelling and What if? analysis with pivot tables - Tuto
  • Interested in Excel pivot tables? Start here
  • Consolidating multiple worksheets in a Pivot Table tutorial
  • Excel 2000/XP pivot table tutorial - Budgeting
  • Tutorial 2 - Sales Analysis
  • Custom sort on pivot table columns
  • Consolidate won't show all columns
  • Deleted data reappears
  • New worksheet per cost centre
  • Excel Pivot Table Selection
  • Macro to change pages
  • Consolidate - only one row and column
  • Pivot does Count, not Sum
  • XL Cubed?
  • Autofill - How do I get a summary of categories
  • Customise sort order
  • Can you consolidate?
  • Show empty columns in a pivot table
  • Pivot table values still there after delete
  • Getting near the 65000 rows limit
  • Consolidation budgets in PTs
  • Formatting stick in PTs
  • PT defaults to count
  • Pivots across pages
  • Pivots consolidation - make a budget
  • Pivot tables formatting (double click sheet)
  • Number formatting in PTs
  • PT Resource planning
  • Resoucer planning appendix
  • Can't get my pivot table to produce two grand totals
  • Pivot table - combining multiple data sources
  • Pivot table AutoFormat Help
  • Can't group dates in pivot table
  • How do I calculate margin percentage in a pivot table?
  • Cumulative totals in pivot tables for non-December year-ends
  • Back to Index

  • ExcelZone Compendium - importing & exporting digest
  • Exporting multiple Excel sheets to .csv?
  • Can Excel be extended past 65k rows?
  • Importing data results in negative zeroes!
  • Python and Excel
  • Excel - Length of worksheet
  • Analysing exported data within Excel
  • Excel -How to convert text representing a negative
  • Import account 0021 and 311 = date 31 Jan
  • Export dates wrong format
  • Text problem import over 65000
  • Export tab-separated list
  • Text import
  • OCR scanning into Excel
  • How can I convert a PDF file to Excel?
  • Back to Index

  • Excel Query
  • Sage data via ODBC
  • Excel and Microsoft Query
  • Excel Calculate
  • Lotus to Excel import
  • Microsoft Query manual
  • Pivots and Query
  • Numbers appears as Text with OBDC link?
  • Autorefresh in Sage ODBC
  • Back to Index

  • ExcelZone Digest: Using functions and formulae
  • Index Function
  • Excel functions do not work when linked to closed spreadsheet
  • Weighted average formula
  • SUMPRODUCT
  • Excel NETWORKDAYS function
  • Excel - Problems with SUM fuction
  • Excel functions
  • Excel Formual Needed
  • Another Excel Formula Needed
  • Excel formula
  • Either Gum or get data matching two criteria
  • Excel Formulae Help
  • Spreadsheet functions
  • Excel - can you have an intentional circular reference
  • Excel formula for calculating Debtors & Credit
  • Excel 3D formulas
  • Nested functions in Excel?
  • Cell reference as header/footer
  • Cell reference to another file?
  • ROUND formula
  • indirect function cell ref in a formula
  • Extracting values from a string
  • Transpose function
  • Function wizard in XP
  • Getpivotdata function in Excel
  • How can I test text for a string?
  • Excel financial functions
  • Formula won't recalculate automatically
  • Back to Index

  • ExcelZone Compendium - Practical tips for using SUMIF() and IF()
  • Excel again.
  • More Excel probs
  • How to use IF expression
  • SUMIF in excel
  • SUMIF & AND functions
  • 'Countif' function in Excel
  • If statements
  • SUMIFs linking to other workbooks
  • Nulls in Excel If statements (macros?)
  • SUMIF
  • Dates in SUMIF
  • SUMIF puzzler with ranges
  • SUMIF Formula for two criteria
  • TimeSheet spreadsheet & multiple IF query
  • Back to Index

  • Practical uses for Lookup and Reference functions
  • Sort of a two variable Lookup table
  • Mapping accounts in Excel
  • Lookup in Excel
  • Can anyone help with Vlookup problems?
  • Help with Excel
  • Excel: Using Match & Index to replace Vlookup
  • How can I stop getting #Div/0
  • Excel Vlookup
  • Excel - Looking up data
  • Using Excel’s Vlookup function to add fields
  • Vlookup
  • Vlookup gives wrong answer
  • Vlookup not available
  • Vertical Look Up Table
  • Back to Index

  • ProductivITy Tip: Tackling a simple Excel macro
  • Emulating Excel's Autosum feature as a macro
  • Macros in Excel 97
  • Self-running macros in Excel
  • Excel 97: How do I automate running sensitivities ?
  • Opening an Excel file
  • Excel Macro Problem
  • Excel Macro Question
  • Excel macro query
  • Macros for Footers in Excel
  • Distribute Excel macro
  • Simple One Buton Macro for Watermarks
  • Excel Macro - Printer selection
  • Excel graphs and auto macros
  • Excel Macro Running Problem
  • Opening a specified sheet
  • Running Macros with if statement
  • Excel auto copy macro
  • Macros slow in XP
  • Macro for copying dates
  • Can you assign two macros to the same button?
  • Macros: how do I activate on opening the workbook?
  • Macro to update form number when it's printed
  • Back to Index

  • Using Visual Basic to copy a whole cell within a table
  • Excel VBA tip o' th' day
  • Why Copy/Paste macro - works in VBE but not in Excel?
  • Visual basic - Macro
  • Excel VBA for extracting from a range in a list
  • Copy cells (with fomat/formula) using VB Code
  • Spin button in Excel
  • VB script required
  • Excel VBA code to find empty area
  • VBA routine to save file based on sheet name
  • VB code to identify column where active cell is located
  • Back to Index

  • Excel Worksheet Protection
  • Prevent hidden columns being seen
  • Excel - prevent hidden columns being seen?
  • Hiding formulae in Excel
  • Password box in Excel
  • How to protect a formula in Excel?
  • UnProtecting Objects in Excel
  • Excel AutoFilter command & worksheet protection
  • Excel password
  • More Excel Passwords
  • Protect formulae in a template
  • Unhiding multiple worksheets in Excel
  • Different Excel Problem - Honest!
  • Controlled Stationery - protecting cells
  • Security protect cells
  • Protected spreadsheet rows
  • Back to Index

  • Automatic invoice generation
  • Build your own Excel Net to Gross function - Tutorial
  • Use Excel to cut your BT phone bill - by Peter Hool
  • Excel spreadsheet to calculate corporation tax
  • IRR spreadsheet setup
  • Calculating Mortgage Repayments on Excel
  • Excel formats for Limited Liability Partnerships
  • Loan Manager - Excel 2000
  • Scanning ceque numbers into Excel
  • Excel NPV calc
  • Formula for compound interest
  • Help - Cash flow model required
  • Excel invoice templates
  • Leaseback model or formula in excel
  • Club accounts
  • Back to Index

  • How do I upload budgets from Excel into Sage?
  • QuickBooks question relating to items and Excel export
  • Sage departmental Excel reporting
  • How to use Excel for bank reconciliation
  • Reporting project P&Ls in Excel
  • How can you export a sales daybook from QuickBooks?
  • Nested sub-totals

    Back to Index

  • Excel hyperlink screentips
  • Excel to Access Convertion
  • Moving data between systems using Access and Excel
  • Converting Lotus to Microsoft
  • PC Excel model to use on Mac
  • Using Lotus 1-2-3 Formulas in Excel
  • Microsoft Excel/Word problem
  • Can Excel fire up Outlook?
  • Linking Excel spreadsheets to Word.
  • Date problems in PC-Mac migration
  • Linking Excel into Word
  • Combining Excel with Word
  • Quattro Pro conversion
  • Mailshot and Word/text to columns
  • Copying Excel into Word
  • Mail merge
  • Excel files on server

    Back to Index

  • Huge Excel Workbook
  • File size
  • Excel files have become read only
  • Illegal Operation in Excel
  • Excel file has become unopenable
  • Data Integrity Check on MS Excel
  • Excel File is corrupt: Help Needed
  • Problem opening file
  • Excel 97 crashes in Excel 2002
  • Duplication of Excel files
  • File corruption
  • Formula problem
  • Excel on XP?
  • Excel upgrade?
  • File repairs, anyone?
  • Recover lost file
  • Mouse not working
  • Storage problem - lots of RAM
  • Problem saving Excel 2000
  • Lost the data entry at top of sheet
  • Screen handing in Excel
  • Cannot open Template Wizard
  • Back to Index

    Replies (3)

    Please login or register to join the discussion.

    avatar
    By mung1
    03rd Jun 2006 13:13

    Insert $ for absolute cell ref
    I have forgotten how to edit and insert $ sign into a cell reference by toggling 2 keys. e.g edit cell ref A2 to $A$2.

    Can any remember this 2 key key stroke?

    Thanks

    Thanks (0)
    avatar
    By barb24
    05th Nov 2006 10:15

    Re: Insert $ for absolute cell ref
    Press F2 to go to edit mode. Then pressing the F4 key will toggle between $A$1, A$1 and $A1.
    Hope that helps,
    Barbara.

    Thanks (0)
    avatar
    By David Carter
    04th Jul 2006 22:48

    F4
    keep tapping the F4 key

    Thanks (0)