Advertising
Advertising

Google Docs Gets A Facelift

Google Docs Gets A Facelift

More than just looking pretty, Google Docs & Spreadsheets has gotten an organizational facelift.

Now instead of just tagging your documents, you can drag and drop everything into folders. You will also notice anything you’ve tagged previously, is now in a corresponding folder. The Google team have additionally added a Google Suggest-esque seach to your docs – but I’ve, personally, never seen much use in this.

It’s a welcome change to make everything more manageable over there at Google Docs, but nothing really ground breaking. So here are some Google Doc & Spreadsheet shortcuts:

Docs AND Spreadsheets

Shift+Tab = Move to previous cell in table (documents) or row (spreadsheets)

Tab = Move to next cell in table (documents) or row (spreadsheets)

Google Docs Gets A Facelift

Ctrl+S = Save

Ctrl+U = Underline

Advertising

Ctrl+Y = Redo

Ctrl+B = Bold

Ctrl+C = Copy

Ctrl+I = Italicize

Ctrl+P = Print

Ctrl+R = Right alignment (documents) Copy Right (used in combo with Shift + arrow) (spreadsheets)

Docs

Ctrl+A = Select all

Ctrl+E = Center alignment

Advertising

Ctrl+H = Replace

Ctrl+J = Full justify

Ctrl+K = Insert link

Ctrl+L = Left alignment

Ctrl+M = Insert comment

Ctrl+Shift+L = Bulleted list

Ctrl+Shift+Space = Insert non-breaking space

Ctrl+Space = Remove formatting

Ctrl+1 = Header style 1 etc

Advertising

Spreadsheets

Ctrl+D = Copy Down (used in combo with Shift + arrow)

Ctrl+End = Go to last cell in data region

Ctrl+Home = Go to first cell in data region

Ctrl+left-arrow = Go to left-most cell in data region (current row)

Ctrl+right-arrow = Go to right-most cell in data region (current row)

Ctrl+down-arrow = Go to bottom-most cell in data region (current column)

Ctrl+up-arrow = Go to top-most cell in data region (current column)

Ctrl+Page Down = Move to next worksheet (IE only)

Advertising

Ctrl+Page Up = Move to previous worksheet (IE only)

F2 = Edit active cell

Enter = Move to next cell in column

Esc = Cancel cell entry

Shift+Enter = Move to previous cell in column

Shift+page up/down = Extend the selection up/down one screen

Ctrl+spacebar = Select entire column

Shift+spacebar = Select entire row

Shift+down, up, left, right arrow key = Manual select

An entirely new way to stay organized – [Google]

Google Docs & Spreadsheets Keyboard Shortcuts – [Google]

More by this author

Craig Childs

Craig is an editor and web developer who writes about happiness and motivation at Lifehack

8 Steps to Continuous Self Motivation Even During the Difficult Times How Not To Suck At Socializing – Do’s & Don’ts Ten Ways to Improve Your Quality of Life How To Initiate Conversation Storage Ideas For Small Spaces

Trending in Technology

1 7 Tools to Help Keep Track of Goals and Habits Effectively 2 7 Clever Goal Tracker Apps to Make the Most of Your Business in 2019 3 10 Smartest Productivity Software to Improve Your Work Performance 4 18 Best Time Management Apps and Tools (2019 Updated) 5 16 Less Known Gmail Hacks That Will Super Boost Your Productivity

Read Next

Advertising
Advertising
Advertising

Last Updated on February 15, 2019

7 Tools to Help Keep Track of Goals and Habits Effectively

7 Tools to Help Keep Track of Goals and Habits Effectively

Now that 2011 is well underway and most people have fallen off the bandwagon when it comes to their New Year’s resolutions (myself included), it’s a good time to step back and take an honest look at our habits and the goals that we want to achieve.

Something that I have learned over the past few years is that if you track something, be it your eating habits, exercise, writing time, work time, etc. you become aware of the reality of the situation. This is why most diet gurus tell you to track what you eat for a week so you have an awareness of the of how you really eat before you start your diet and exercise regimen.

Tracking daily habits and progress towards goals is another way to see reality and create a way for you clearly review what you have accomplished over a set period of time. Tracking helps motivate you too; if I can make a change in my life and do it once a day for a period of time it makes me more apt to keep doing it.

So, if you have some goals and habits in mind that need tracked, all you need is a tracking tool. Today we’ll look at 7 different tools to help you keep track of your habits and goals.

Joe’s Goals

Advertising

     

    Joe’s Goals is a web-based tool that allows users to track their habits and goals in an easy to use interface. Users can add as many goals/habits as they want and also check multiple times per day for those “extra productive days”. Something that is unique about Joe’s Goals is the way that you can keep track of negative habits such as eating out, smoking, etc. This can help you visualize the good things that you are doing as well as the negative things that you are doing in your life.

    Joe’s Goals is free with a subscription version giving you no ads and the “latest version” for $12 a year.

    Daytum

      Daytum

      is an in depth way of counting things that you do during the day and then presenting them to you in many different reports and groups. With Daytum you can add several different items to different custom categories such as work, school, home, etc. to keep track of your habits in each focus area of your life.

      Advertising

      Daytum is extremely in depth and there are a ton of settings for users to tweak. There is a free version that is pretty standard, but if you want more features and unlimited items and categories you’ll need Daytum Plus which is $4 a month.

      Excel or Numbers

        If you are the spreadsheet number cruncher type and the thought of using someone else’s idea of how you should track your habits turns you off, then creating your own Excel/Numbers/Google spreadsheet is the way to go. Not only do you have pretty much limitless ways to view, enter, and manipulate your goal and habit data, but you have complete control over your stuff and can make it private.

        What’s nice about spreadsheets is you can create reports and can customize your views in any way you see fit. Also, by using Dropbox, you can keep your tracker sheets anywhere you have a connection.

        Evernote

        Advertising

          I must admit, I am an Evernote junky, mostly because this tool is so ubiquitous. There are several ways you can implement habit/goal tracking with Evernote. You won’t be able to get nifty reports and graphs and such, but you will be able to access your goal tracking anywhere your are, be it iPhone, Android, Mac, PC, or web. With Evernote you pretty much have no excuse for not entering your daily habit and goal information as it is available anywhere.

          Evernote is free with a premium version available.

          Access or Bento

            If you like the idea of creating your own tracker via Excel or Numbers, you may be compelled to get even more creative with database tools like Access for Windows or Bento for Mac. These tools allow you to set up relational databases and even give you the option of setting up custom interfaces to interact with your data. Access is pretty powerful for personal database applications, and using it with other MS products, you can come up with some pretty awesome, in depth analysis and tracking of your habits and goals.

            Bento is extremely powerful and user friendly. Also with Bento you can get the iPhone and iPad app to keep your data anywhere you go.

            Advertising

            You can check out Access and the Office Suite here and Bento here.

            Analog Bonus: Pen and Paper

            All these digital tools are pretty nifty and have all sorts of bells and whistles, but there are some people out there that still swear by a notebook and pen. Just like using spreadsheets or personal databases, pen and paper gives you ultimate freedom and control when it comes to your set up. It also doesn’t lock you into anyone else’s idea of just how you should track your habits.

            Conclusion

            I can’t necessarily recommend which tool is the best for tracking your personal habits and goals, as all of them have their quirks. What I can do however (yes, it’s a bit of a cop-out) is tell you that the tool to use is whatever works best for you. I personally keep track of my daily habits and personal goals with a combo Evernote for input and then a Google spreadsheet for long-term tracking.

            What this all comes down to is not how or what tool you use, but finding what you are comfortable with and then getting busy with creating lasting habits and accomplishing short- and long-term goals.

            Read Next