Mar 17, 2023 ... I really miss the Excel Camera Tool that let you create images of another part of a spreadsheet that updates, allowing a floating live copy.

May 6, 2022 ... Borders keep appearing randomly in one specific column when copying data from another spreadsheet (added screenshot below). Only way to hide ...

Jun 27, 2023 ... the best way to do this is to add an extra column for that data entry. ... You can then "hide" the column with the calculated value if you want.

Feb 22, 2021 ... I am new to all of this and I have searched for days for an answer. I see this is do able in Excel. Any and all help would be appreciated.

Nov 22, 2021 ... I have several sheets that utilize the Group rows/columns feature. I want to create multiple groups based on months, so each month can be ...

Oct 11, 2021 ... I then only need the data in columns D:H to keep the first row and delete the duplicate data below it. Not all data has duplicates that need to ...

Feb 11, 2021 ... I have searched online, some suggested hiding the columns ... Some even suggest switching the roles, i.e. create a master sheet without sensitive ...

Oct 12, 2021 ... I have a Google Sheet that contains over 50 charts whose data source is within only one big data table. Now I need to delete several useless rows.

Aug 14, 2020 ... A Filter View allows individual users to view subsets of the data, filtering or sorting the rows, without affecting the view of other users.

Mar 26, 2019 ... For some reason when I'm in an unprotected/unlocked cell with data it will delete the data after approx 20-30 seconds.

May 26, 2021 ... ... cells without having to manually update (there's around 10000 functions). ... data and your hand-entered expected results from that data.

Apr 6, 2022 ... A filter view lets you do that "privately" without affecting what other concurrent users see. ... A1:BZ } in cell A1 , hide the columns you ...

Jul 17, 2019 ... If I protect a cell/range/column/row, someone without the right ... Having protected cells (or columns) is a common use case for a spreadsheet ...

Mar 14, 2022 ... When I type my content into a cell it will spill out onto adjacent cells. Ideally I'd like the "overflow" content to be hidden until I click on ...

Oct 4, 2020 ... Unfortunately, adding a new column will require some TLC to all the existing formulas. Maybe you do the upgrade now, maybe you keep it in mind ...

Jun 15, 2020 ... I use hidden sheets to do all the calculations and the "Form" page is data validated to the cells on the hidden sheet. Helps keep other ...

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 ...

Mar 12, 2020 ... Basically someone using the spreadsheet without syncing, but still ... You can adjust this under DATA > Data Validation for any given cell.

Jun 15, 2019 ... ... columns. However, the names of the people in the rota are also in a column, so as you scroll along, the names become hidden. I have provided ...

Jun 20, 2020 ... Please keep in mind the data goes one direction in this example so ... So you can't edit that column in the master, just like they can't edit your ...