Using Shortcuts To Add Data To a Numbers Spreadsheet

A new action in Shortcuts for Mac allows you to add a row of data to a Numbers spreadsheet. You can prompt for information and then record a time and some data. Numbers version 12 is required. An older technique allows you to change existing data in a Numbers spreadsheet.

Comments: 7 Responses to “Using Shortcuts To Add Data To a Numbers Spreadsheet”

    Mark Stacks
    5 months ago

    Gary, Thanks for this video on "Using Shortcuts". I've wanted a way to enter the date and time in a cell without having to manually enter the characters. When using formulas, I haven't managed to automatically populate the new date/time in the next data row without the date/time changing every time I open the spreadsheet. This shortcut does the trick without multiple cells converting to a static date.

    Thanks again. Mark

    Gene
    5 months ago

    Good video Gary. I have a master spreadsheet. I take data (CSV files) each month and add it to the master. They monthly sheets contain all of the columns of the master but not in the correct order. Is there a way to use Shortcuts (or Automator) to automatically move the columns around so that the incoming table will match the columns of the master sheet? Thanks in advance.

    5 months ago

    Gene: There may be a way, but it would never be worth it. If you only do this monthly, just bring the CSV into a new Numbers document, drag and drop the columns to arrange, and then copy and paste those rows into your main spreadsheet. You'd have to do that for 12 months a year for decades in order for it to be worth automating.

    Anthony
    1 month ago

    Excellent video Gary. I tried following you step by step using my iPad, when I got to the quit step, I was not able to find the "Quit App - Numbers" It's not available. Is there another way of doing it? I need to quit after entering the data. Thanks again.

    1 month ago

    Anthony: This is a tutorial for Mac. I was just quitting to show the app launches when you use this. You don't need to quit on the iPad. But I don't know if this will work at all on the iPad. I never checked.

    Anthony
    1 month ago

    Have you done a shortcut to enter data quickly into the business spreadsheet(video), where you can just enter the expense or income from the shortcut directly into the spreadsheet app, then close it?

    1 month ago

    Anthony: It sounds like you are asking for exactly what I am showing in this video.

Leave a New Comment Related to "Using Shortcuts To Add Data To a Numbers Spreadsheet"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)