CALL US: +65 6817 6277    |     Whatsapp US

Data Recovery Service & Data Recovery Singapore
  • HOME
  • DATA RECOVERY
    • DEVICE TYPES
      • CCTV Recorder Systems
      • Drones Device
      • PC, Laptop & Tablets
      • Mobile Phones
      • RAID Servers
    • FILE TYPES
      • Emails (PST,IMAP,OST)
      • Files (Documents, Database)
      • Password Recovery
      • Photos, Videos, Audio
      • WhatsApp Mobile Apps
    • 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
  • FORENSICS
    • FORENSIC SERVICES
      • Forensic Mobile Malware Scan
    • ENTREPRISE SOLUTIONS
      • Cellebrite Endpoint Inspector
      • Cellebrite Digital Collector
      • Cellebrite Physical Analyzer
      • Cellebrite UFED
      • Cellebrite UFED Cloud
    • FORENSIC SOFTWARES
      • Digital Forensic Softwares
  • PRODUCTS
    • DATA RECOVERY TOOLS
      • Rusolut
    • DATA RECOVERY SOFTWARES
      • Video Data Recovery Softwares
    • FORENSICS TOOLS
      • Cellebrite Endpoint Inspector
      • Cellebrite Digital Collector
      • Cellebrite Physical Analyzer
      • Cellebrite UFED
      • Cellebrite UFED Cloud
    • FORENSIC SOFTWARES
      • Digital Forensic Softwares
  • SUCCESS STORIES
  • CONTACT
  • HOME
  • DATA RECOVERY
    • DEVICE TYPES
      • CCTV Recorder Systems
      • Drones Device
      • PC, Laptop & Tablets
      • Mobile Phones
      • RAID Servers
    • FILE TYPES
      • Emails (PST,IMAP,OST)
      • Files (Documents, Database)
      • Password Recovery
      • Photos, Videos, Audio
      • WhatsApp Mobile Apps
    • 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
  • FORENSICS
    • FORENSIC SERVICES
      • Forensic Mobile Malware Scan
    • ENTREPRISE SOLUTIONS
      • Cellebrite Endpoint Inspector
      • Cellebrite Digital Collector
      • Cellebrite Physical Analyzer
      • Cellebrite UFED
      • Cellebrite UFED Cloud
    • FORENSIC SOFTWARES
      • Digital Forensic Softwares
  • PRODUCTS
    • DATA RECOVERY TOOLS
      • Rusolut
    • DATA RECOVERY SOFTWARES
      • Video Data Recovery Softwares
    • FORENSICS TOOLS
      • Cellebrite Endpoint Inspector
      • Cellebrite Digital Collector
      • Cellebrite Physical Analyzer
      • Cellebrite UFED
      • Cellebrite UFED Cloud
    • FORENSIC SOFTWARES
      • Digital Forensic Softwares
  • 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 dns domain Email Files file sharing Folders Hard Disk Drive imap internet IP address IPv4 laptop laptop data recovery singapore Microsoft mobile phone data recovery singapore Office 365 OneDrive Online outlook pop3 Recovery regedit repair hard disk Singapore server Sharing sharing files Singapore data recovery centre storage troubleshooting virus Web Portal Window windows windows 7 windows 10 wireless Zimbra

ARCHIVES

  • September 2023 (1)
  • July 2023 (1)
  • May 2023 (2)
  • April 2023 (4)
  • March 2023 (6)
  • February 2023 (4)
  • April 2022 (2)
  • March 2022 (1)
  • January 2022 (1)
  • October 2021 (1)
  • September 2021 (1)
  • August 2021 (1)
  • July 2021 (5)
  • June 2021 (3)
  • May 2021 (1)
  • April 2021 (1)
  • March 2021 (4)
  • February 2021 (1)
  • January 2021 (4)
  • 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

September 2023
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  
« Jul    

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 (107)
  • Devices (11)
  • Hard Drive (8)
  • Other Storage Devices (10)
  • Servers (2)

About EHDR Data Recovery

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

1100 Lower Delta Road,
#02-02 EPL Building,
Singapore 169206

DATA RECOVERY SERVICE

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

Our Blog

  • Everything You Need To Know About The Data Recovery Process
  • EVER HIGHER DATA RECOVERY CENTRE (EHDR) Expands into Cambodia Market in Partnership with Grep Tech (Cambodia)
  • The Ultimate Guide to Deleted Data Recovery: Expert Tips and Techniques

Working Hour

Mon - Fri: 9:00 - 18:00

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

Sun: Closed

Data Recovery Service & Data Recovery Singapore
  • Home
  • About Us
  • Forensic
  • Blog
  • FAQ
  • Contact
  • |
  • Privacy Policy
  • |

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