Finding a new job is always a hassle.
Fortunately, it doesn’t have to be that way.
you’re free to also customize it to include what you deem important.
You don’t need advanced knowledge to create a job tracker in Google Sheets.
Yet, it can help you quickly secure your next job.
What Is a Job Tracker?
First things first, let’s break down what we expect from a job tracker.
This tracker should list and organize your job applications and progress.
Create a blank spreadsheet, and let’s get started!
This will give your spreadsheet its main structure.
We’ll take care of that in the next step!
Add Some Color and Style
Now it’s time to give the cells some style.
Color the Cells
snag the main headings and give each a different color.
Color the subheadings in groups so that they’re distinguishable from one another.
snag the main headings and increase the font size to 24.
The default font size is 10.
Next, select all the main headings and subheadings, then bold the font style.
If any of the subheadings are overflowing, drag the border and increase the column’s width.
you could also center the texts so that they look tidier.
Merge the Main Headings
Right now, each of the main headings is spilled into multiple cells.
To fix this, choose the cells and then clickMerge cellsso that they’re grouped together.
That’s about it for the basic styling in your Google Sheets job tracker.
you’re able to furtherformat your spreadsheet and make it look professional.
The list can include options like Yes, No, or other short strings.
choose the cells that you want to add a dropdown list to and go to theDatatab.
Then, selectData validation.
This will bring up Data validation on the right.
Change theCriteriatoDropdownand input the items you want.
Color coding is key!
However, you’ve got the option to make navigation smoother by freezing the job information heading.
you might also lock the headings so that you don’t accidentally move or edit them.
Freezing the job information cells will save you a trip back to the beginning of the spreadsheet.
pick the last cell in the heading you want to freeze.
If you’ve selected a different cell, then the selected cell’s column will show up instead.
Protect the Headings and Subheadings
Protecting the structural cells in your spreadsheet will prevent accidental changes.
snag the headings and subheadings, and then right-choose the selected range.
In the right-click menu, clickView more cell actionsand then selectProtect range.
This will bring up Protected sheets & ranges on the right.
UnderProtected sheets & ranges, clickSet permissionsand checkShow a warning when editing this range.
Now, if you accidentally edit the headings, Google Sheets will prompt a warning.
Use Your Job Tracker
Congratulations!
Your Google Sheets job tracker is now ready for use!
you’re free to add date stamps by selecting the cell and pressingCtrl+;on your keyboard.
If you want to add a time stamp, pressCtrl+Shift+;on your keyboard.
Google Sheets is web-based, so you could use your job tracker on any of your devices.
You don’t need to download a job tracker app to keep track of your applications.
Google Sheets allows you to create your own custom job tracker, tailored to suit your needs.
Your job tracker now has different color-coded sections, dropdown lists, and a fixed information section.
You know you won’t mess it up by accident because you’ve protected the headings.
Well then, what are you waiting for?
Let the job hunt begin!
