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 [...]
Tag Archives | Excel 2010
A PDF file is used a lot more of document distribution and publishing. Since it is a lot easier to deal with than the default file formats in Office. Luckily for us, Office 2010 has conversion tools to convert your documents to PDFs. Here is how to convert Office 2010 files to PDF using the built [...]
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.
Having a lot of Office documents open can be very counter productive especially if you only have one monitor. There is an easy and free way to create tabs in Word 2010, Excel 2010 and PowerPoint 2010 to help minimize the clutter on your computer. Here is how to add tabs in Word 2010, Excel [...]
In Excel 2010 just like any other version of Excel you usually see letters, ABC, in the columns. If you want to change Excel 2010 columns to numbers, like 123, or change them back to letters here is how to do it. Change Excel 2010 Columns to Numbers Open Excel 2010 and click on the [...]
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.
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.