Live Collaboration Support: If your team needs to work together through a spreadsheet, it’s imperative that the software supports simultaneous collaboration.The software should also have cross-platform support, so you can access them anywhere. The best Excel alternatives have a clean modern look and smart tool organization, and are stocked with a ready artillery of built-in formulas, functions, and templates. An Intuitive Interface: Spreadsheets are designed to handle complex tasks, but that doesn’t mean that the software itself should be clunky or difficult to use.Here are the most important features good spreadsheet software should offer, and why they’re important:
What to Look for in a Microsoft Excel Alternativeįree spreadsheet software should be just as powerful as paid options and come stocked with all the tools you need to spreadsheet your heart out.
Best for Serious Data Analysis: Zoho Office Sheet. Closest to Microsoft Excel: WPS Office Spreadsheets. Best Open-Source Excel Alternative: LibreOffice Calc. Best for Apple Users: Apple iWork Numbers. Best Cloud-Based Excel Alternative: Google Sheets. What to Look for in a Microsoft Excel Alternative. Also, if you are using Windows, you can refer to some existing articles to learn more Google Sheets shortcuts on Windows. TipsMake above article has just introduced you to the list of Google Sheets shortcuts on macOS. Shift + right click: displays the browser context menu. Cmd + Shift + F: Switch to Compact mode (hide menu). Cmd + Option + Shift + K: open the Input Tools menu. Ctrl + Option + A : Open the Accessibility menu. Ctrl + Option + H : open the Help menu. Ctrl + Option + T: Open the Tools menu. Ctrl + Option + O: Open the Format menu. Ctrl + Option + I: Open the Insert menu. Ctrl + Option + V : Open the View menu. Ctrl + Option + F : Open the File menu. Shortcuts to access the Google Sheets menu on macOS Ctrl + Option + I + O : insert column to the right.Ħ. Ctrl + Option + I + C: insert column to the left. Ctrl + Option + I + W: insert the rows below. Ctrl + Option + I + R: insert the rows above. Cmd + D: copy data from the first column to selected cells below.Ĭmd + R: copy data from the first row to the selected right rows.Ĭmd + Enter: copy data from the first cell into other selected cells. Google Sheets keyboard shortcuts work with rows and columns Fn + F9: toggle the preview of results.ĥ. Cmd + Shift + Enter : insert the array formula. Ctrl + -: show all formulas in the worksheet. Google Sheets shortcuts to manipulate formulas Ctrl + Cmd + Shift + M : move Focus out of the worksheet.Ĥ. Option + Shift + K: show a list of all sheets. Option + down / up arrow : if you are working on a lot of pictures, use this Google Sheets shortcut to move, open the next or previous sheet. Cmd + Backspace: scroll to the current working cell. Cmd + Fn + left arrow: move to the beginning of the sheet.Ĭmd + Fn + right arrow: move to the end of the sheet. Fn + right arrow: move to the end of the row. Fn + left arrow: move to the beginning of the row. Ctrl + Option + arrow up / down: move to the first or last cell in a column. Ctrl + Option + arrow left / right: move to the first or last cell in a row. Arrow keys left / right / up / down: move left, right, up or down the cell. Google Sheets keyboard shortcuts move around the spreadsheet Ctrl + Shift + 5: format by percentage.Ĭmd: remove all formatting from the selected cells.ģ. Ctrl + Shift + 1: format as a decimal number. Option + Shift + 6: remove the border from the selected cells. Cmd + Shift + 7: add a border to the selected cells. Here are the Google Sheets keyboard shortcuts that format cells on macOS:Ĭtrl + Shift + E (Windows / Chrome OS) or Cmd + Shift + E (macOS): Center align a cell. Similar to Excel, Google Sheets also supports many keyboard shortcuts that you can use to format worksheet cells. 
Google Sheets keyboard shortcuts format cells Cmd + Option + Shift + H : open spreadsheet revision history.Ģ.
Cmd + H: find and replace in a worksheet. Cmd + X: cut selected cells to clipboard.Ĭmd + V: paste the content copied into the worksheet. Cmd + C: copy the selected cells to the clipboard. Here's a list of the Google Sheets keyboard shortcuts on macOS that can be used to manipulate common tasks, like copying or selecting columns of rows: Google Sheets shortcut operations in general Google Sheets keyboard shortcuts on macOSġ. To open a list of Google Sheets keyboard shortcuts on macOS, just press Cmd + /. Using the Google Sheets shortcut on macOS is a faster and simpler way to manipulate spreadsheets.
0 kommentar(er)
