'Excel Tips and How-to' category archive, page 21

How to avoid automatic data formatting in Excel

Excel is a helpful program when you have standard tasks and standard data. Once you want to go your non-standard-Excel way, some frustration is involved. Especially when we have large data sets. I came across one of such formatting issues when I dealt with our customers' tasks in Excel. Continue reading

Tutorial with Excel examples about Macros

Many people think that it is extremely hard to learn Excel Macros, but it is not. This article contains some nice and simple Examples to automate your daily tasks in Excel... Continue reading

How to rotate Excel charts or worksheets: quick tip

Certain worksheets or charts may look much better if you change their orientation. So in today’s how-to article we’ll have a look at how to rotate Excel table or chart. Continue reading

Enter multiple lines in a single Excel cell

When you have a lot of text in your Excel cells it can be a good idea to show it on more than one line. But how? Every time you enter text into a cell it longs to be on one line however long it is. Here is how you can insert more than one line into one cell on your worksheet... Continue reading

Microsoft Excel Charts: Tips, Tricks and Techniques

Some tips, tricks and techniques for better looking charts in Microsoft Excel. Continue reading

Update Data in Excel with Merge Tables Wizard

There are some tasks in Excel that take so long to do and which are so tedious that you wonder why there isn't an automated way to do them. One task that falls into this category is that of updating a table with data stored in another table. You either need to spend a lot of time and exercise a lot of patience and care to perform the task manually or hand it over to the experts in the form of the Merge Tables Wizard from AbleBits. Continue reading

Bring classic toolbar back to Office 2010, 2007

If you use Microsoft Office 2007/2010 and you are still not used to the new interface, or the Ribbon is the only reason that stops you from upgrading, here are several suggestions how to integrate the old and the new and get familiar command bars in Office 2007-2010... Continue reading

View Excel workbooks side by side

You’d like to compare two Excel worksheets and need to open and see them side by side. However simple it may seem, each time they appear in the same window. That’s frustrating! So we will show you how to view two Excel files (.xls or .xlsx) side by side in this step by step tip. Continue reading

Look up with Lookups in Excel

When you need to find information in a table of data, the lookup functions in Excel can help you do it. While there was a lookup wizard in earlier versions of Microsoft Excel that made the process of creating a lookup quite easy, this is no longer available in Excel 2010. Now, when you need a lookup formula you'll have to create it manually. Read this post to harness the power of lookups for your Excel worksheets... Continue reading

Get rid of "The file is corrupt and cannot be opened" in Excel 2010

Usually when upgrading you expect nothing but improvements. So it can be really disappointing when after moving to Excel 2010 you have no chance to access your xls. file. You understand what I’m talking about if you ever encountered the "The file is corrupt and cannot be opened" error in Excel 2010. Still think it can’t open? Actually it can! Continue reading

Applying multiple Subtotals to your Excel table

Using Subtotals is much more flexible than I put in my previous post about it. Here I would like to expand – literally - the Subtotal function to show some other options that might help you do the work ... Continue reading

How to Consolidate Data in Excel 2013 - 2003

There are many ways to consolidate data in Microsoft Excel. You can use the Table feature and its associated filters, you can create PivotTables, or you can consolidate large amounts of data into a summary form. In this post I'll show you how to use the Consolidate data feature in Excel to take data from a series of worksheets – or workbooks – and summarize them into a single worksheet. Continue reading

Creating and using Custom Lists in Excel

If you have to work with a spreadsheet that will always have the same list of information, or maybe you just don't want to use copy/paste every time, it would be most beneficial to have a pre-set list stored so that Excel can help you with what you are trying to do. Having a Custom List is the way to go and I'm going to show you how you can create a custom list in Excel. Continue reading

Merge all your Students' Data into a single Excel File

School has begun again as hot summer days gave way to classrooms full of students. With tighter budgets we are facing classrooms with more students and less time for getting to know them. With all the data scattered in different reports, let me show you how quickly you can create a single Excel data binder using Merge Tables Wizard… Continue reading

How to group data in an Excel Pivot Table to help further summarize and analyze your data

When you're working with a PivotTable in Excel you may find that you have a lot of data in the table that needs to be summarized even further. This can be done by grouping the data and in this post I'll explain how to do this Continue reading

Interactive elements in Excel with Spin Buttons and Scroll Bars

Whenever your user has a discrete number of choices to make for inputting data into an Excel worksheet you can save time by automating how they enter this data. You can do this in a number of ways and one of them is to use a spin button or a scroll bar to do the work... Continue reading

Conditional formatting in Excel Pivot Tables

With the release of Excel 2007, Microsoft provided some additional conditional formatting options such as data bars and icon sets which makes it easy to apply formats to cells to show visually the relative values in those cells. Microsoft also changed how conditional formatting is applied to PivotTables which gives you a greater flexibility when using conditional formats with data summarized in a PivotTable... Continue reading

Hello, World - why we are starting one more blog for Office users

We initially started creating our add-ins for Microsoft Office applications to make some common tedious tasks simple and fast. A few thousand support requests later, we decided to start this blogging tips site... Continue reading

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21