Microsoft Excel Shortcut Keys

This is a listing of Microsoft Excel shortcut keys. Some keys are only supported on the new versions of Microsoft Excel.

The shortcut keys below are very useful when you work on Microsoft Exceldocuments often. Try to memorize some of these keys, whichever you feel you would use more often and practice yourself with those keys. You'll find a big help on your work. Just to make your life easier!

Use this trick at your own risk.
Shortcut Description
Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + P Bring up the print dialog box to begin printing.
Ctrl + Z Undo last action.
F2 Edit the selected cell.
F5 Goto a specific cell. For example, C6.
Shift + F5 Bring up search box.
F7 Spell check selected text and/or document.
F11 Create chart.
Shift + F3 Open the Excel formula window.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert New Worksheet.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks / windows.
Ctrl + Page up Move between Excel work sheets in the same Exceldocument.
Ctrl + Page down Move between Excel work sheets in the same Exceldocument.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = Create a formula to sum all of the above cells
Ctrl + ' Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + ^ Format number in scientific format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space Select entire column.
Shift + Space Select entire row.

The followings are some mouse shortcuts for Microsoft Excel

Shortcut Description
Double-click Edit cell
Double-click Double-click on the column divider will resize the column width to fit content
Double-click Double-click on the row divider will resize the row height to fit content
Triple-click Selects the entire contents in the cell
Click and drag column divider Resize column width. This also works with multiple columns.
Click and drag row divider Resize column height. This also works with multiple rows.
Ctrl + Mouse wheel Zooms in and out of document.

Comments

Rai Singh RanaMarch 16, 2024 at 7:51 AM
Best For Computer Education
ReplyDelete
Replies

Add comment

Separation of Mixtures Experiment

Separation of mixtures is a basic and important concept in chemistry. This experiment helps students learn how different substances can be separated using simple methods. In this article, we will explain the separation of mixtures experiment, materials required, and easy step-by-step process for students. 🧪 What is a Mixture? A mixture is a combination of two or more substances that are not chemically combined. 👉 Example: Sand and salt Rice and pulses Oil and water 🧰 Materials Required Sand Salt Water Beaker or bowl Filter paper or cloth Funnel Spoon Heat source 🛒 Amazon Affiliate Products (Use These) Glass Beaker Set Filter Paper Pack Plastic Funnel Heating Plate Scie...

324 Days Money Saving Challenge: सिर्फ 324 दिनों में ₹1,11,600 की बचत!

Money saving tips in Hindi, 324 days saving challenge. क्या आपने कभी सोचा है कि रोज़ाना बचाए गए ₹100, ₹200 या ₹500 आपको लखपति बना सकते हैं? हम अक्सर सोचते हैं कि बड़ी बचत के लिए बहुत बड़ी आमदनी का होना ज़रूरी है, लेकिन सच तो यह है कि बचत आपकी सैलरी से नहीं, बल्कि आपकी आदतों से होती है। आज मैं आपके साथ एक ऐसा 'Saving Challenge' शेयर कर रही हूँ जो आपकी वित्तीय स्थिति (Financial Condition) को पूरी तरह बदल सकता है। Best saving plan! Save 1 lakh rupees in a year 324 दिनों का बचत चैलेंज (The 324-Day Challenge) इस तालिका (Table) को ध्यान से देखें। इसमें कोई मुश्किल रॉकेट साइंस नहीं है, बस निरंतरता (Consistency) और अनुशासन (Discipline) का मेल है: हर दिन का लक्ष्य: अपनी जेब और सुविधा के अनुसार रोज़ाना 100, 200 या 500 रुपये बचाएं। समय सीमा (Duration): केवल 324 दिन। कुल परिणाम (Total Amount): ₹1,11,600 सोचिए, सिर्फ़ एक साल से भी कम समय में आपके पास 1 लाख से अधिक की ठोस राशि होगी! यह तरीका क्यों सफल है? जेब पर हल्का बोझ: रोज़ाना 100 या 200 रुपये बचाना बहुत बड़ा त्याग नहीं लगता। यह आप...

Reflection of Light Experiment

Reflection of light is a basic concept in physics that explains how light bounces off surfaces. This simple experiment helps students understand how mirrors form images. In this article, we will explain the reflection of light experiment, materials required, steps, and its working principle. 🔦 What is Reflection of Light? Reflection of light is the bouncing back of light rays from a surface like a mirror. 👉 It follows two important laws: Angle of incidence = Angle of reflection Incident ray, reflected ray, and normal lie in the same plane 🧰 Materials Required Plane mirror Laser pointer or torch White paper Protractor Scale and pencil 🛒 Amazon Affiliate Products (Use These) Plane Mirror for Experiments Laser Pointer Pen Geometry Box (Protractor + Scale) White Chart Paper Science Experime...

Simple Electric Circuit Project

A simple electric circuit is one of the easiest and most important science projects for students. It helps you understand how electricity flows and how basic electrical devices work. In this article, we will explain the simple electric circuit project, required materials, steps, and useful Amazon affiliate products you can use. ⚡ What is a Simple Electric Circuit? A simple electric circuit is a closed path through which electric current flows. It has three main parts: Power source (battery) Conducting wires Load (bulb or LED) 👉 When the circuit is complete, electricity flows and the bulb glows. 🧰 Materials Required Here are the basic items needed for this project: Battery (9V or AA) Battery holder Connecting wires Small bulb or LED Switch (optional but recommended) Insulation tape 🛒 Amazon Affiliate Product...

Water Purification Project

Clean water is essential for health and survival. This simple water purification project helps students understand how dirty water can be cleaned using basic methods. In this article, we will explain how to make a water purification model, materials required, steps, and its working principle. 💧 What is Water Purification? Water purification is the process of removing impurities from water to make it safe for use. 👉 It removes: Dirt Sand Harmful particles 🧰 Materials Required Plastic bottle (cut into half) Cotton Sand Gravel (small stones) Charcoal Dirty water Container 🛒 Amazon Affiliate Products (Use These) Activated Charcoal Powder Gravel Stones Pack Cotton Roll Plastic Funnel DIY Science Project Kit 🔧 Steps to Make Water Purification Model 1️⃣ Take a plastic bottle and cut it 2️⃣ Turn the top part upside down like a funnel 3️⃣ Add layers inside: Cotton (bottom) Charcoal Sand Gravel (top) 4️⃣ Pour dirty water slowly 5️⃣ Collect filtered water below 👉 Water becomes cleane...

Human Digestive System Model

Have you ever wondered what happens to food after you eat it? 🤔 The human digestive system is responsible for breaking down food and turning it into energy. In this project, we will create a simple and interesting model of the human digestive system that helps students understand how digestion works step by step. 🍽️ What is the Digestive System? The digestive system is a group of organs that work together to digest food. 👉 Main parts include: Mouth Food pipe (esophagus) Stomach Small intestine Large intestine Each part has a special role in digestion . 🧰 Materials Required Chart paper or cardboard Colored clay or thermocol Fevicol or glue Sketch pens or markers Scissors Straw or pipe (for esophagus) 🛒 Amazon Affiliate Products (Use These) Color C...

Human Eye Working Model

The human eye is one of the most important organs of our body. It helps us see the world around us. This working model helps students understand how the eye forms images. In this article, we will explain how to make a human eye working model, materials required, steps, and its working principle. 👁️ What is the Human Eye? The human eye is an optical organ that captures light and sends signals to the brain. 👉 Main parts: Cornea Lens Retina Optic nerve 🧰 Materials Required Cardboard or thermocol Convex lens Small box or container White paper (screen) Glue and tape Cutter and scissors 🛒 Amazon Affiliate Products (Use These) Convex Lens for Experiments Thermocol Sheet / Cardboard School Craft Kit Adhesive Glue Science Project Kit 🔧 Steps to Make Human Eye Model 1️⃣ Take a box to represent t...

Working Model of Electric Motor

An electric motor is a device that converts electrical energy into mechanical energy. It is used in fans, mixers, washing machines, and many other appliances. In this article, we will explain how to make a working model of an electric motor, materials required, steps, and how it works. ⚡ What is an Electric Motor? An electric motor works on the principle that a current-carrying conductor placed in a magnetic field experiences a force. 👉 This force causes rotation, which makes the motor work. 🧰 Materials Required Battery (9V or AA) Copper wire (enameled) Magnet (strong) Safety pins or paper clips Connecting wires Switch (optional) Wooden base/cardboard 🛒 Amazon Affiliate Products (Use These) Strong Neodymium Magnet Copper Coil Wire (Enamelled) 9V Battery with Connector Battery Holder Mini Switch Breadboard Kit Jumper Wires Set DIY Science Project Kit 🔧 Steps to Make Electric Motor 1️⃣ Take copper wire and make a coil (10–15 turns) 2️⃣ Scrape insulation from ends of the wire 3️⃣ Fix ...

Electromagnet Making Project

An electromagnet is a type of magnet that works using electricity. It is widely used in devices like electric bells, motors, and cranes. In this article, we will explain how to make an electromagnet, materials required, steps, and its working principle. ⚡ What is an Electromagnet? An electromagnet is a magnet that becomes active only when electric current flows through it. 👉 When current flows → magnet is ON 👉 When current stops → magnet is OFF 🧰 Materials Required Iron nail (or iron rod) Copper wire (enameled) Battery (1.5V or 9V) Connecting wires Switch (optional) Paper clips (for testing) 🛒 Amazon Affiliate Products (Use These) Copper Coil Wire (Enamelled) Iron Nails Pack 9V Battery with Connector Battery Holder Mini Switch Jumper Wires Set DIY Science Project Kit 🔧 Steps to Make Electromagnet 1️⃣ Take an iron nail 2️⃣ Wrap copper wire tightly around it (20–30...

Crystallization of Salt Experiment

Crystallization is a simple and interesting chemistry process used to purify substances. This experiment helps students learn how pure salt crystals are formed from a solution. In this article, we will explain the crystallization of salt experiment, materials required, and very easy step-by-step instructions for students. 🧂 What is Crystallization? Crystallization is a process in which a solid forms from a solution in the shape of crystals. 👉 It is used to: Purify substances Separate solids from liquids Form beautiful crystals 🧰 Materials Required Common salt Water Beaker or bowl Spoon Heat source (stove or heater) Thread and stick (optional) 🛒 Amazon Affiliate Products (Use These) Glass Beaker Set Laboratory Heating Plate Stirring Rod ...

SHOBHA RANA BLOG

Search This Blog