Making a table is a great way to organize your data in Microsoft Excel. This feature is only available for Excel 2007 and up. If you still have an older version of Excel, you can use ranges to organize your data. But you will not get the added benefits for having a nice table. Here […]
Tag Archives | Excel 2007
How to and Help Articles about Excel 2007 which includes spreadsheet, VBA coding or marco help, and various functions and formulas.
If you spend a lot of time copying and pasting data from on Excel sheet to another you might want to think about automating the process. Automating task in Excel can be easily done by using a macro or with some VBA code. For this tutorial we will show you how to copy cell value in VBA […]
Microsoft Excel has many functions. One of them is called the ISERROR function. With ISERROR you can return a true or false value if there is an error or not. Here is how to use the ISERROR function in Excel 2010. ISERROR Function Syntax Before we show an example of how the ISERROR function works […]
Love using Excel as a financial tracking spreadsheet or a calculator? Here is an easy way to calculate a loan payoff in Excel 2010
Here is a quick Excel how to! Remove those hidden shapes or objects form your workbook to help speed it up or just reduce its file size.
Have you ever had the need to print each column header in Excel 2010 on every page in the workbook, here is how you can do this.
When working with a workbook or spreadsheets you might want to print first row on every page in Excel 2010. Here is how to do this.
We have shown you how to get the Column number from Excel 2007 using the Column Function. But what if you need the actually letter for a macro in your VBA code? Here is how you do it. Here is the Code, don’t worry I’ll explain in a second: Sub Convert_Column_Letter() Dim MyColumn As String, […]
Excel Column Function lets you return the number associated with a Column. For example Column(B2) would return 2 since B is the 2nd column.
We have shown you How to Require a Password to Open an Excel 2010 or 2007 Workbook, but what happens if you have Excel 2003? You missed the upgrade and I didn’t write a way for you to stop all those peeping Toms from staring at your precious workbook? Well don’t worry about it! Here is a great and easy way to set a password to open or modify an Excel workbook from 2003-2010.