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
Convert Office 2010 Files to PDF
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 [...]
ISERROR Function in Microsoft Excel 2010
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 [...]
Calculate Loan Payoff in Excel 2010 the Easy Way
Love using Excel as a financial tracking spreadsheet or a calculator? Here is an easy way to calculate a loan payoff in Excel 2010
Excel How To: Remove Hidden Shapes and Objects
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.
Add Tabs to Word 2010, Excel 2010, and PowerPoint 2010
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 [...]
Change Excel 2010 Columns to Numbers Or Back to Letters
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 [...]
Print the First Column on Every Page in Excel 2010
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.
Print First Row on Every Page in Excel 2010
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 Tutorial
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.