The right hand side Log in bar has disappeared. Is there any way to correct this without starting over?
This is what I am seeing instead:
Are you referring to the Getting Started Steps in columns L-W?
Have you checked if those columns are hidden?
2 Likes
@rachel.dewitthuberts I agree with @Mark.S those do look like columns that are supposed to be hidden.
For the benefit of anyone reading this thread who may not know how to hide and unhide columns I am going to provide a few tips.
In your Tiller spreadsheet you will notice there are many columns that are hidden that help hide the magic of how the charts and calculations are displayed. One way to detect hidden columns is the jump in letters for the column indicators. It’s subtle, I don’t always notice hidden columns. You can also look for the double arrows indicating there are columns hiding in there.
If you click on these arrows, the columns will expand. I certainly have accidentally clicked on them many times. Thank goodness for Control Z to undo the ooopsie quickly.
In Excel it is more subtle. You will notice a double line between columns instead of a single line.
For the double arrows to show up in Excel you will want to hover over the indicator.
To hide columns in a spreadsheet you will want to highlight the columns. This can be a tad tricky with a trackpad. Click and hold down on the column indicator and drag to select desired columns.
Alternatively, click on the column indicator and hold down the SHIFT key. Use the right (or left) arrow, while holding down Shift, to select multiple columns.
Once the columns are selected you can right click to select hide columns or use the search icon, the first icon in the toolbar, to search for hide and select to hide columns.
I am a big fan of keyboard shortcuts so here are the shortcuts for both Excel and Google Sheets. Note that I am a Mac user.
Control Shift Zero on PC to hide columns for both Excel and Google Sheets
Option Command Zero on Mac for both Excel and Google Sheets
-Alice
Tiller Evangelist
1 Like
Noting that for the Spending Trends sheet, these column’s visibility are controlled via grouping, instead of hiding. Selecting the +/- icon box above column J controls the visibility.
1 Like
Thanks, Marc! I am back on track now!
2 Likes