I talk about productivity and improving the efficiency of Excel spreadsheets on this blog but I`ve never actually discussed one of the primary ways that I save time when working in Excel. In the past, I`ve talked about adding the most common things that I do to save time. There`s no doubt that creating macros and using powerful functions in order to automate some processes are key but I probably save as much if not more time by simply “not searching” for functions in the Excel spreadsheets. How? You’ve probably heard of the most famous keyboard shortcuts:

Ctrl-C: Copy
Ctrl-V: Paste

These are clearly the ones I use most, not only in Excel but on my computer in general. Here are a few others that I use a lot:

CTRL+PgUp:Switches between worksheet tabs, from left-to-right.
CTRL-F: Find
Shift+Space: Select entire row

You can also get a full list on this PDF from the Microsoft website.

This certainly solves most of my issues but there are some functions that are more complex to use as shortcuts but that I use over and over. What do I do with those? Simply add the icons to the top of my Excel bar in order to make it much easier to do. How? Let’s take the example of “Paste as Values” which I tend to do all the time. How?

-Click on File

-Click on options

-Click on “Quick Access Toolbar”

-Find the exact function and click add

After that it will appear at the top of your “Excel” application:

Easy enough? I promise that you will be very surprised at how much time this will end up saving you.

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss

***************************************************

Posted on 13 October 2014 by Leslie Currently, Comments and Pings are both off.

87 Feedbacks on "Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity"

http://eduxpert.Ingitglobal.com/component/k2/author/34118

http://eduxpert.Ingitglobal.com/component/k2/author/34118

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

16 August 2017 at 14:19

screamindolly.com

screamindolly.com

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

17 August 2017 at 19:05

miracleexchange.org

miracleexchange.org

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

23 August 2017 at 11:54

Business Computers

choice Computer Technologies

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

14 January 2018 at 20:51

boiler installation costs average

boiler installation and repair

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

30 May 2018 at 9:40

cryptocurrency investments

cryptocurrency investments

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

06 August 2018 at 8:13

Shopping ที่ไหน สินค้าอะไรดี ของขวัญวันเกิด ของขวัญปีใหม่ ซื้อให้หัวหน้า ซื้อให้ลูกน้อง ร้านออน

Shopping ที่ไหน สินค้าอะไรดี ของขวัญวันเกิด ของขวัญปีใหม่ ซื้อให้หัวหน้า ซื้อให้ลูกน้อง ร้านออนไลน์ เตาปิ้ง ปิ้งย่าง บาร์บีคิว

Experiments in Finance

26 January 2019 at 22:33

lắp đặt vách ngăn thạch cao giá rẻ tphcm

lắp đặt vách ngăn thạch cao giá rẻ đức phát

Experiments in Finance

31 March 2019 at 23:52

ร้านค้าคุณภาพลาซาด้าออนไลน์

ร้านค้าคุณภาพลาซาด้าออนไลน์

Experiments in Finance

21 May 2019 at 0:17

download

download

Experiments in Finance

05 July 2019 at 5:06

http://Dafallen.freehostia.com

http://Dafallen.freehostia.com

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

08 September 2019 at 17:02

klik mouse halaman web berikutnya

klik mouse halaman web berikutnya

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

12 January 2020 at 12:05

halaman internet yang terhubung

halaman internet yang terhubung

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

18 January 2020 at 14:13

Baca Lebih Lanjut Di Sini

Baca Lebih Lanjut Di Sini

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

19 January 2020 at 12:35

judi dadu

judi dadu

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

19 January 2020 at 23:44

% domain_as_name% menerbitkan sebuah artikel

% domain_as_name% menerbitkan sebuah artikel

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

22 January 2020 at 20:17

klik disini sekarang

klik disini sekarang

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

25 January 2020 at 1:45

bacaan yang fantastis

bacaan yang fantastis

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

28 January 2020 at 1:27

klik melalui halaman web yang akan datang

klik melalui halaman web yang akan datang

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

28 January 2020 at 17:10

더킹카지노쿠폰

더킹카지노쿠폰

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

12 February 2020 at 15:02

camera vantech quận 1 2 3 4 5 6 7 8 9 10 11 12 tân bình bình tân

camera vantech quận 1 2 3 4 5 6 7 8 9 10 11 12 tân bình bình tân

Experiments in Finance

25 February 2020 at 1:45

พนันบอลออนไลน์

พนันบอลออนไลน์

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

03 March 2020 at 16:58

오션파라다이스게임

오션파라다이스게임

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

04 March 2020 at 8:07

Pedestrian Accident Lawyer

Pedestrian Accident Lawyer

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

31 March 2020 at 18:47

Dog Attack Lawyer near Los Angeles CA

Dog Attack Lawyer near Los Angeles CA

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

31 March 2020 at 18:56

솔레어카지노

솔레어카지노

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

03 April 2020 at 5:15

릴게임야마토

릴게임야마토

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

06 April 2020 at 11:39

스위피게임

스위피게임

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

10 April 2020 at 4:31

고양이 발정기

고양이 발정기

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

15 April 2020 at 22:40

เกมออนไลน์

เกมออนไลน์

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

16 April 2020 at 22:02

샌즈카지노주소

샌즈카지노주소

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

20 April 2020 at 12:52

더킹카지노주소

더킹카지노주소

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

15 May 2020 at 5:06

예스카지노

예스카지노

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

27 May 2020 at 19:54

더존카지노

더존카지노

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

06 June 2020 at 20:10

เล่นสล็อต

เล่นสล็อต

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

06 June 2020 at 21:14

please click the next web page

please click the next web page

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

07 June 2020 at 12:07

고양이교배

고양이교배

Using Excel Keyboard (and other) Shortcuts To Dramatically Increase Productivity | Experiments in Finance

23 June 2020 at 22:48

Excel function tutorials, Excel spreadsheets (.xls)