Posts Tagged 'Excel'

Apr
17

How to make Excel print gridlines

One of the most common complaints about gridlines is that they are not printed by default. In this article you’ll learn how to print gridlines in Excel and get these faint lines brighter on a hard copy by changing the default gridline color. Continue reading

Apr
9

6 Reasons Why Your VLOOKUP is Not Working

The VLOOKUP function is the most popular lookup and reference function in Excel. It is also one of the trickiest and the dreaded #N/A error message can be a common sight. This article will look at the 6 most common reasons why your VLOOKUP is not working. Continue reading

Mar
28

Move Excel spreadsheets online, share, embed on a web page and make interactive

With the emergence of Excel Online, you no longer need cumbrous HTML code to export your tables to the web. Just save your workbook online and access it literally from anywhere, share with other users and work on the same sheet all together. Continue reading

Mar
21

How to convert Excel tables to HTML

If you created a pretty Excel table and now want to publish it online as a web page, the simplest way is to export it to an old good html file. In this article, we are going to explore several ways of converting Excel data to HTML, determine pros and cons of each, and walk you through the conversion process step-by-step. Continue reading

Mar
19

Get the new Ultimate Suite and save another 10 minutes every day.

For the last 6 months we have been working on a new version of Ultimate Suite that includes 20 helpful add-ins for Excel. We tried to get the most out of Excel to achieve our main goal: speeding up Ultimate Suite for you to get really quick results with less time and energy invested! Continue reading

Mar
13

Alternating row colors and column shading in Excel (banded rows and columns)

See how you can quickly alternate row and colomns colors in your worksheets by using Excel Table Styles. You will also learn a few smart formulas to highlight banded rows and columns with 3 different colors and to shade groups of rows based on a value change. Continue reading

Mar
6

How to transpose tables in Excel – convert rows to columns and vice versa

In this article, you will find several ways to convert rows to columns and columns to rows in Excel. These solutions work in all versions of Excel 2013, 2010, 2007 and lower, cover many possible scenarios, explain most typical mistakes and provide good examples of using Excel's Transpose function. Continue reading

Feb
27

How to split cells in Excel: Text to Columns, Flash Fill and formulas

In this article you will find several options to split cells and entire columns in Excel 2010 and 2013. Examples and screenshots illustrating the use of Text to Columns and Flash Fill features as well as a handful of formulas to separate names, text and numerical values will help you choose the best approach for splitting your data in Excel. Continue reading

Feb
21

How to print row and column headers of Excel spreadsheets on every page

Today I'd like to tell you about a small but important feature tucked away in Excel 2013 and its previous versions. In this article you'll learn how to make header rows and column headers print on each page. Continue reading

Feb
6

How to merge rows in Excel 2010 and 2013 without losing data

This article provides solutions for 4 different scenarios of merging rows in Excel. See how you can quickly merge multiple rows without losing data; how to combine duplicate Excel rows, how to repeatedly merge blocks of rows, and how to consolidate matching rows from two different spreadsheets. Continue reading

Older posts »