Google Sheets Class > #22 GAME OVER

[Kiki]

In Apple computers, you have to use COMMAND instead of CONTROL, but the same thing happens.

You are right! I can't remember if there are other keyboard differences like this or not. I'll get on my Mac today.


I think from now one I will highlight the cells that I type in/on your sheets in RED so you will spot them easy. Once you read them go ahead and delete them.

 

[RoyalChick]

Oh dear. I am now back home with reliable internet access. I considered flunking out of class but in real life I already used the nifty trick of making the column width fit the text so I decided to try and catch up instead.
Imagine my despair - my sheet has disappeared. Is it possible it doesn't auto-save somewhere? It really seems to be gone.
I am not sure I can face starting from the very beginning.

 

[casportpony]

Oh dear. I am now back home with reliable internet access. I considered flunking out of class but in real life I already used the nifty trick of making the column width fit the text so I decided to try and catch up instead.
Imagine my despair - my sheet has disappeared. Is it possible it doesn't auto-save somewhere? It really seems to be gone.
I am not sure I can face starting from the very beginning.

Check here:
https://drive.google.com/drive/my-drive

 

[Kiki]

Oh dear. I am now back home with reliable internet access. I considered flunking out of class but in real life I already used the nifty trick of making the column width fit the text so I decided to try and catch up instead.
Imagine my despair - my sheet has disappeared. Is it possible it doesn't auto-save somewhere? It really seems to be gone.
I am not sure I can face starting from the very beginning.

When you log in to your Google Sheets app or the Google website, there are different options on how to choose which you see on the home screen.

By default, I believe it is the most recent sheet you have edited would be at the top of the list.

Are you not seeing it on your list of sheets at all or are you meaning that you have accidentally deleted everything on your sheet?

 

[RoyalChick]

When you log in to your Google Sheets app or the Google website, there are different options on how to choose which you see on the home screen.

By default, I believe it is the most recent sheet you have edited would be at the top of the list.

Are you not seeing it on your list of sheets at all or are you meaning that you have accidentally deleted everything on your sheet?

I think I found it. First mistake was not using my new Google account which was the very first thing I learned in this class. But then I figured that out.
So I have something - says I last edited Sept 25th so I just need to check it is up to date because I didn't leave until the 28th so I thought there would be a more recent version.
But either way, I am nearly back in business.
Thank goodness I didn't try this with dodgy internet or I would have gone completely nuts!
Back soon (I hope).

 

[RoyalChick]

ASSIGNMENT 16
Create Drop Down List

Highlight Cells G4:G30
Click Data
then Data validation
View attachment 3275515

Next under CRITERIA select LIST OF ITEMS
View attachment 3275518
Type these things in this blue circled box:
Landscape, Portrait, Square, Too Small
View attachment 3275521

View attachment 3275526
click SAVE



View attachment 3275527

Done - I am intrigued to see what this can do!

 

[RoyalChick]

Assignment 17
Fill in column G by selecting an option from the drop down list for each picture linked in column C.

Done

 

[RoyalChick]

Portrait or Landscape is good enough for now.

Oh. I picked a couple as square. I think they were just about landscape but very, very close to square. Should I go back and make them landscape?

 

[RoyalChick]

View attachment 3276432View attachment 3276433

You can only get that second view with the dimensions if you save all the pics to your computer. Right?

 

[RoyalChick]

Ok so we left off here.
I'm working on #18 now.

Hold on. I thought #18 was to share with you. I am ready to do that any time.