Q&A for How to Use Google Spreadsheets

Return to Full Article

Coming soon

Add New Question

Question

How do I maintain the data size on the spreadsheet without effecting the task bar at the bottom. I know I an zoom in size but this also reduces the size/image of the task bar

Kyle Smith
wikiHow Technology Writer
Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.

Kyle Smith

wikiHow Technology Writer

Expert Answer

Using Google Sheet's zoom feature (found in the taskbar next to the formatting painting tool) will increase or decrease the cell sizes without changing the taskbar and menu sizes.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

I am new with spread sheets, so the publisher has set us up on a online spread sheet. In making chnges this morning i accidentally deleted 2 columns B & C . How do I bring them back to show on the spr

Kyle Smith
wikiHow Technology Writer
Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.

Kyle Smith

wikiHow Technology Writer

Expert Answer

You can see and revert to previous versions of a Google Sheet by opening the file, going to File > Version history > See version history. Then, click the version that has the deleted data and press "Restore this version" at the top of the page.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 1
Question

How do you open a Google Sheet that has been sent to you in an email

Kyle Smith
wikiHow Technology Writer
Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.

Kyle Smith

wikiHow Technology Writer

Expert Answer

You can click the link to the Google Sheet in the email. There might be a button that says "Open" in the email. Alternatively, you can go to your Google Drive, click Shared with me in the left menu, and open the shared Google Sheet file from there.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

How can I create a spreadsheet and fill in A, B, C (etc.) columns with my own headers while maintaining number sequence on the left side?

Community Answer

Unfortunately, there's no way to replace the lettered headers themselves. You'll need to create your own headers in the very first row underneath those letters. Note, however, that you can freeze that (or any other) new header row so that it remains in place when scrolling or sorting the data underneath. You'll find the Freeze option under the View tab.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 9
Question

Does one have to have a Gmail account to use Google Sheets?

Community Answer

No, you don't have to have a Gmail account.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 3
Question

How do I delete a sheet?

Community Answer

Select the sheet, right click the tab of the sheet you want to delete. then select delete.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 2
Question

How do I bold lines horizontally and vertically?

Community Answer

By clicking on the initial row number or column letter, you'll note that the entire range of data in that row or column has been highlighted. Once selected, simply click on the Bold button (an uppercase "B") on the toolbar or select the Format tab and then click Bold.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 1
Question

I have photos in a spreadsheet and want to copy and save them separate from the sheet. How do I do this?

Community Answer

Simply drag the photo(s) from the spreadsheet to your desktop or whatever folder in which you wish it to be saved. Note that if you select the photo (by clicking on it without moving it), a "drag" function will appear that only allows you to move the photo within the spreadsheet itself. In other words, to save it outside of the spreadsheet, you must select and move it at the same time.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 2
Question

Can Google Docs be set so that only you can view them?

Community Answer

Yes. In fact, this is the default setting for any Google Doc that you've created. If you wish to adjust these settings, click the blue Share button in the upper, righthand part of the screen. This allows you to determine whether others can view, edit or comment upon your document—and whether you opt to share it with anyone else in the first place.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 3
Question

Is there a way to share a Google sheet with others so that they can make their own copy of the worksheet but not edit the original?

Rtiav

Community Answer

Yes. After the person has shared the Google Sheet, they can click 'File' and press 'Make a Copy'. You do not have to give the person editing access.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0