CALL US: +65 6817 6277    |    Quick Support

#1 Data Recovery Service & Data Recovery Singapore
  • HOME
  • ABOUT US
  • DATA RECOVERY
    • DEVICE TYPES
      • PC, Laptop & Tablets
      • Mobile Phones
      • RAID Servers
    • FILE TYPES
      • Files (Documents, Database, Emails)
      • Photos, Videos, Audio
    • STORAGE DEVICES
      • External Hard Disk Drive (HDD)
      • Hard Disk Drive (HDD)
      • Network Attached Storage (NAS)
      • SD Card / Micro SD / CF Card
      • Solid State Drive (SSD)
      • USB Thumb Drive / Flash Drive
  • PRODUCTS
    • Data Recovery Tools
      • Rusolut
    • Videos Data Recovery Software
  • SUCCESS STORIES
  • CONTACT
  • HOME
  • ABOUT US
  • DATA RECOVERY
    • DEVICE TYPES
      • PC, Laptop & Tablets
      • Mobile Phones
      • RAID Servers
    • FILE TYPES
      • Files (Documents, Database, Emails)
      • Photos, Videos, Audio
    • STORAGE DEVICES
      • External Hard Disk Drive (HDD)
      • Hard Disk Drive (HDD)
      • Network Attached Storage (NAS)
      • SD Card / Micro SD / CF Card
      • Solid State Drive (SSD)
      • USB Thumb Drive / Flash Drive
  • PRODUCTS
    • Data Recovery Tools
      • Rusolut
    • Videos Data Recovery Software
  • SUCCESS STORIES
  • CONTACT

LATEST

POSTS & TUTORIALS
Homepage > Blog > 7 Excel Shortcuts You May Not Know
August 10, 2018  |  By Bernice

7 Excel Shortcuts You May Not Know

accounting-1928237_1920

1) One Click – Select All

Instead of using Ctrl+ A to select all cells in a range, you can just simply click on the Triangle button as shown below to highlight all the data within a worksheet.

2. Open your Excel Files Simultaneously

Instead of Clicking each excel file to open one by one, by highlighting the select files+ press enter, all 3 workbooks will open simultaneously

3. Toggle between different Excel Files

With a simple shortcut Ctrl + Tab, you can toggle between different excel files. This shortcut is also applicable for switching within tabs of your browser (Whether it may be using Google Chrome or Firefox).

Shift Different Excel Files

4. The Quick Access Toolbar

The Quick Access Toolbar is a useful tool that enables you to customize your most frequently used actions onto a quick and easy to access toolbar.

 

5. Drawing a Diagonal Link in a Cell

If you will like to create a diagonal link in the cell to separate different attributes into rows and columns. How do you do it? Go to Home > Font > Borders > Click on More Borders, you will be able to see the diagonal border at the bottom.

Add Diagonal Line for a Cell

6. Add a Group of New Rows/Columns

Instead of wasting time inserting the rows one by one, instead you can right click on the highlighted rows or columns and choose Insert from the drop down menu….and voila new rows will be inserted above the row or to the left of the column you first selected.

7. Move or Copy Data in Cell Quickly

If you will like to move one column of data in a worksheet quickly and swiftly, you can press the Ctrl button before you drag to move and the new column will copy all the selected data.

All Beginner Cell Columns Control Convenient Copy Ctrl Easy Excel Move Rows Select Shortcut
Previous StoryWestern Digital Red NAS Hard Disk Recovery
Next StoryHow to Spot a Counterfeit SD Card

Related Articles

  • windows-7-1995426_1280
    How to Create a "Show Desktop" Button on Taskbar

TAGS

Anti Virus Cloud Command Prompt computer data data recovery data recovery company Singapore desktop domain Email Files file sharing Folders imap internet IPv4 laptop laptop data recovery singapore Microsoft mobile phone data recovery singapore Office 365 OneDrive onedrive for business Online online drive outlook pop3 Recovery regedit server Sharing sharing files Singapore data recovery centre smtp storage telnet troubleshooting virus Web Portal Window windows windows 7 windows 10 wireless Zimbra

ARCHIVES

  • January 2021 (2)
  • December 2020 (4)
  • November 2020 (3)
  • May 2020 (1)
  • April 2020 (1)
  • November 2019 (1)
  • October 2019 (4)
  • September 2019 (5)
  • August 2019 (4)
  • July 2019 (5)
  • December 2018 (1)
  • August 2018 (1)
  • June 2018 (1)
  • April 2018 (2)
  • March 2018 (1)
  • October 2017 (3)
  • July 2017 (1)
  • May 2017 (4)
  • April 2017 (1)
  • March 2017 (3)
  • February 2017 (5)
  • January 2017 (2)
  • December 2016 (2)
  • November 2016 (2)
  • October 2016 (2)
  • September 2016 (2)
  • August 2016 (2)
  • July 2016 (2)
  • June 2016 (2)
  • May 2016 (2)
  • April 2016 (2)
  • March 2016 (2)
  • February 2016 (2)
  • January 2016 (2)
  • December 2015 (2)
  • November 2015 (2)
  • October 2015 (1)

CALENDAR

January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Dec    

ABOUT US

We are team of IT expertise who passionately in love with technologies and regularly conducts research & testing to develop new and better IT solutions for difference scales of business. We believe that IT makes business better!

CATEGORIES

  • Blog (65)
  • Devices (9)
  • Hard Drive (7)
  • Other Storage Devices (7)
  • Servers (1)

COME VISIT US

We can help you with all your data recovery needs. A Data Recovery Company You Can Trust!

#02-02, 1100 Lower Delta Rd,
Singapore 169206

OUR SERVICES

Internal & External Hard Disk Data Recovery Service | SD Data Recovery Service | SSD Data Recovery Service | Laptop Data Recovery Service | Server Data Recovery Service | NAS/SAN/DAS Recovery Service | Phone Data Recovery Service | IT Services

Our Blog

  • What is Cleanroom?
  • Pro and Cons of RAID
  • What is RAID?

Working Hour

Mon - Fri: 9:00 - 18:00

Sat: 10:00 - 13:00 (By Appointment Only)

Sun: Closed

#1 Data Recovery Service & Data Recovery Singapore
  • Home
  • About Us
  • IT Services
  • Success Stories
  • Blog
  • |
  • Contact
  • |

© EVER HIGHER DATA RECOVERY CENTRE | All Rights Reserved 2012-2020

Your Data is
Important

We committed to serve you as an essential service provider. Pick up service is available.
We Left No Data Behind!

Contact Us

×

Keep Calm!

Click below to chat on WhatsApp or We Take Call as Per Number Below.

Clients Success Manager
Support Clients Success Manager

Call us to +65 6817 6277 from 09:00 to 19:00 (Mon - Fri)
Whatapps Call to +65 9444 8312 after Working Hour

× Need Help?