Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Share tech news, updates, or what's on your mind.

Sign up to Post

Oy... You ever make some changes to the underlying data columns in a spreadsheet and then not realize that it inadvertently messed up a whole bunch of other pivot tables and charts as a result? Well, I just did... Fortunately, the Google Sheets revision history feature is pretty darn good and just saved me from having to do a bunch of annoying fixes. Thanks, Google!
3
 
LVL 7

Author Comment

by:Brian Matis
@Kyle
Undo buttons are the best.
I kid you not, but whenever I do anything klutzy in real life (knock over a mug, bang my shin on something, etc.) I mentally try to hit Ctrl-Z. Sadly, it never works... ;-)
1
 
LVL 17

Expert Comment

by:Kyle Santos
Truth
1
[Webinar] Lessons on Recovering from Petya
LVL 10
[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Keyboard shortcuts in Google Sheets for inserting a new row:

In Chrome on Windows or Linux:
  • Alt + I, then R
In IE or Firefox on Windows or Linux:
  • Alt + Shift + I, then R
On a mac:
  • Ctrl + Option + I, then R

Just remember I for Insert and R for row.
2
 
LVL 7

Expert Comment

by:Brian Matis
It's funny... I'm incredibly used to using keyboard shortcuts at the OS level and in desktop apps, but I often don't think to check for keyboard shortcuts in web apps. JIRA has been the one major exception—at some point early on in my use of it, they did a good job of encouraging shortcut usage—but this is a great reminder to investigate keyboard shortcut support in other common web apps.
0
 
LVL 9

Author Comment

by:Brandon Lyon
I just got tired of right clicking and selecting insert new line all the time. It's an operation I do frequently on one of my sheets in particular.
1

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.