Edit & format a spreadsheet - Computer (2024)


Edit & format a spreadsheet - Computer (1)

Want advanced Google Workspace features for your business?

Try Google Workspace today!

You can add data to a spreadsheet, then edit or format the cells and data.

Edit data in a cell

  1. Open a spreadsheet in Google Sheets.
  2. Click a cell that’s empty, or double-click a cell that isn’t empty.
  3. Start typing.
  4. Optional: To add another line within a cell, press ⌘ + Enter on a Mac or Ctrl + Enter on Windows.
  5. When you’re done, press Enter.

Edit & format a spreadsheet - Computer (2)

Format one or more cells

  1. Open a spreadsheet in Google Sheets.
  2. Click a cell, then drag your mouse across nearby cells you want to select, or hold on a Mac or Ctrl on Windows and click another cell.
  3. To format text or numbers in a cell, use the options in the toolbar at the top.

Format your data

Here are some options for formatting your cells or text. You can find these options above the document.

  • Edit & format a spreadsheet - Computer (3) Undo
  • Edit & format a spreadsheet - Computer (4) Redo
  • Edit & format a spreadsheet - Computer (5) Bold
  • Edit & format a spreadsheet - Computer (6) Italic
  • Edit & format a spreadsheet - Computer (7) Strikethrough
  • Change font or font size
  • Edit & format a spreadsheet - Computer (8) Change text color
  • Edit & format a spreadsheet - Computer (9) Change cell fill color
    • Single color
    • Alternating colors
  • Edit & format a spreadsheet - Computer (10) Change cell borders
    • Edit & format a spreadsheet - Computer (11) Change border color
    • Edit & format a spreadsheet - Computer (12) Change border style
  • Edit & format a spreadsheet - Computer (13) Merge cells
  • Change horizontal text alignment
  • Change vertical text alignment
  • Rotate text in a cell
  • Edit & format a spreadsheet - Computer (14) Wrap text in a cell

To format part of the text or content in a cell, double-click the cell, select what you want to format, then select a formatting option.

Align & resize objects

Move an object anywhere you want or change its size. Lines will appear that show what it lines up with, equal space between objects, and when one object is the same size as another.

Format numbers & dates in a cell

  1. Select the cell to be formatted.
  2. At the top, click Format Edit & format a spreadsheet - Computer (15) Number.
  3. From the menu that appears, select the format option you want.
    • If the format option you want isn’t listed: At the bottom of the menu that appears, click custom options, such as "Custom date and time" and "Custom number format."

Learn more about formatting numbers in a spreadsheet.

Add a theme

You can apply changes to the format of an entire spreadsheet with themes.

  1. Open a spreadsheet in Google Sheets.
  2. At the top, click Format Edit & format a spreadsheet - Computer (16)Theme.
  3. Choose an available theme or click Customize to create your own.

Notes:

  • If you create a custom theme, the most recent version will be saved.
  • Colors from your current theme are available in the text and fill color pickers.

Parts of your spreadsheet affected by theme

  • Text font and color of grid text, charts, and pivot tables
  • Hyperlink color of grid text
  • Chart background color
  • Color of series in charts
  • Pivot table background

Note: If you change the format of an item in your spreadsheet, it will override the theme.

Related links

Edit & format a spreadsheet - Computer (17)

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Edit & format a spreadsheet - Computer (2024)

FAQs

How do I edit a spreadsheet on my computer? ›

Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar. This starts Edit mode and positions the cursor in the formula bar at the location that you clicked. Click the cell that contains the data that you want to edit, and then press F2.

How do I change the format of a spreadsheet? ›

Select the cells with the Excel Style. Right-click the applied style in Home > Cell Styles. Select Modify > Format to change what you want.

How do I format a worksheet on my computer? ›

Ways to format a worksheet
  1. Working with document themes. ...
  2. Using styles to quickly format data. ...
  3. Formatting data manually. ...
  4. Using borders and colors to emphasize data. ...
  5. Changing the alignment or orientation of data. ...
  6. Copying an existing format to other data.

How do I format an entire Excel spreadsheet? ›

To do this, click on the tab of the first worksheet, hold the Shift key, and click on the tab of the last worksheet. This will group all the sheets in the workbook together as shown in the screenshot below. Apply any formatting you like to any of the worksheets. That same formatting will be applied to all sheets.

How do I edit an existing spreadsheet? ›

Edit data in a cell
  1. Open a spreadsheet in Google Sheets.
  2. Click a cell that's empty, or double-click a cell that isn't empty.
  3. Start typing.
  4. Optional: To add another line within a cell, press ⌘ + Enter on a Mac or Ctrl + Enter on Windows.
  5. When you're done, press Enter.

How do I change the data format in sheets? ›

Custom formatting of numbers, dates, and currencies
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the data you want to format.
  3. Click Format. Number.
  4. Click Custom date and time.
  5. Search in the menu text box to select a format. ...
  6. Click Apply.

How can you edit and format worksheets? ›

Open a spreadsheet in the Google Sheets app. In your spreadsheet, double-tap the cell you want to edit. Enter your data. Optional: To format text, touch and hold the text, then choose an option.

How do I automatically format a spreadsheet? ›

Click anywhere within the dataset and click Alt+O+A. The AutoFormat window will open with formatting options that work well with your table.

How do I edit an entire Excel spreadsheet? ›

Select a range of cells.

Pressing ⇧ Shift and the spacebar extends a selection throughout the row where the original cell is located. Pressing Ctrl + ⇧ Shift and the spacebar or Ctrl + A will select the entire worksheet.

What is the best practice in formatting spreadsheets? ›

Use consistent formats, codes, spellings, etc. and do not mix data types in a single column. Enter data using consistent formats, for example, always use the same formats for dates. Order similar columns in multiple tables in a similar way.

Why won't my spreadsheet let me edit? ›

Ensure the Excel file is not open in any other location. Check that you have the appropriate permissions to edit the file. Verify that your file isn't corrupted. Ensure your Excel software is updated.

How do I edit a sheet document? ›

Edit data in a cell
  1. Open a spreadsheet in the Google Sheets app.
  2. In your spreadsheet, double-tap the cell you want to edit.
  3. Enter your data.
  4. Optional: To format text, touch and hold the text, then choose an option. To insert a new line, click Insert line break or press Ctrl + Enter.
  5. When done, tap Done .

How do you send a spreadsheet that can be edited? ›

Share your workbook
  1. Select Share.
  2. Set permissions. Allow editing is automatically checked. Uncheck this if you only want to give permission to view the file, not edit it. ...
  3. Enter the names or email addresses of who to share with.
  4. Add a message (optional).
  5. Select Send. Or, select Copy link to get a link to the file.

Top Articles
Canadian Real Estate Market Forecast 2024
What is Shared Reading?
Ffxiv Act Plugin
Odawa Hypixel
855-392-7812
Windcrest Little League Baseball
Shs Games 1V1 Lol
Evil Dead Rise Showtimes Near Massena Movieplex
My Vidant Chart
Florida (FL) Powerball - Winning Numbers & Results
The Blind Showtimes Near Showcase Cinemas Springdale
Amelia Bissoon Wedding
Hood County Buy Sell And Trade
800-695-2780
Conscious Cloud Dispensary Photos
Dark Chocolate Cherry Vegan Cinnamon Rolls
All Obituaries | Buie's Funeral Home | Raeford NC funeral home and cremation
Bank Of America Financial Center Irvington Photos
91 East Freeway Accident Today 2022
Closest Bj Near Me
Amortization Calculator
Violent Night Showtimes Near Century 14 Vallejo
Lisas Stamp Studio
Soulstone Survivors Igg
2011 Hyundai Sonata 2 4 Serpentine Belt Diagram
Cars & Trucks - By Owner near Kissimmee, FL - craigslist
Violent Night Showtimes Near Johnstown Movieplex
EVO Entertainment | Cinema. Bowling. Games.
Ullu Coupon Code
Mosley Lane Candles
Evil Dead Rise - Everything You Need To Know
Persona 4 Golden Taotie Fusion Calculator
Smartfind Express Henrico
The 38 Best Restaurants in Montreal
Watchseries To New Domain
Space Marine 2 Error Code 4: Connection Lost [Solved]
Tds Wifi Outage
The Best Restaurants in Dublin - The MICHELIN Guide
Ferguson Employee Pipeline
Santa Clara County prepares for possible ‘tripledemic,’ with mask mandates for health care settings next month
Powerspec G512
Dickdrainersx Jessica Marie
Grizzly Expiration Date Chart 2023
Florida Lottery Powerball Double Play
Workday Latech Edu
Marcel Boom X
The Jazz Scene: Queen Clarinet: Interview with Doreen Ketchens – International Clarinet Association
Myapps Tesla Ultipro Sign In
Freightliner Cascadia Clutch Replacement Cost
Every Type of Sentinel in the Marvel Universe
Gelato 47 Allbud
Verilife Williamsport Reviews
Latest Posts
Article information

Author: Margart Wisoky

Last Updated:

Views: 5636

Rating: 4.8 / 5 (58 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Margart Wisoky

Birthday: 1993-05-13

Address: 2113 Abernathy Knoll, New Tamerafurt, CT 66893-2169

Phone: +25815234346805

Job: Central Developer

Hobby: Machining, Pottery, Rafting, Cosplaying, Jogging, Taekwondo, Scouting

Introduction: My name is Margart Wisoky, I am a gorgeous, shiny, successful, beautiful, adventurous, excited, pleasant person who loves writing and wants to share my knowledge and understanding with you.