There’s a third kind of “paste special” that I haven’t discussed yet — transposing. When you paste transposed, you’re switching the rows and columns with each other. The cell in C1 (3rd column, 1st row) swaps places with cell A3… Read moreSwitching rows and columns

A while ago I explained why you might want to paste as values, and how to do it in various programs using the “paste special” options. Another possibility with “paste special” is pasting as text. This isn’t quite the same… Read morePasting as text: Basic how-to

The flip side of importing files is, of course, exporting them. In some ways, importing files from another format is easier. If you mess it up, you know right away. With exporting, however, you won’t know until you try to… Read moreExporting files

I mentioned earlier that one very common error code in spreadsheets is what I’ll call the “missing reference error”. In this post I’ll cover the definition of the error, what it looks like in various spreadsheet programs, and some techniques… Read moreSpecific errors: Missing References

In honor of my NCLA presentation I’m going to talk this week about something that I’d previously mentioned, but not addressed: importing files from other formats. I talked previously about comma separated (CSV) and tab delimited values. These formats come… Read moreImporting files