Excel Tutorial
Excel tutorials, quizzes & AI guides — all levels
RSS
  • Online Excel Exercises
  • Training
  • Excel Tests
  • Sitemap
  • Premium Quizzes
  • Shop
  • My account

Tips and tricks

Remove gridlines cover

Remove Gridlines in Excel Easily

Why remove gridlines in Excel? Gridlines help during editing, but can make spreadsheets look cluttered. Removing them creates cleaner, more professional templates perfect for presentations or printing 😎 How to Remove Gridlines Follow these simple steps to hide Excel gridlines: Alternatively: These methods work seamlessly for any spreadsheet, saving you time and effort. Why Avoid Coloring Borders? You can achieve professional results without unnecessary effort by using the correct method described above. Related Articles Want to improve your Excel skills? These articles offer simple tips to save time, avoid mistakes, and work more efficiently with Excel. You will learn useful shortcuts, easy formulas, and smart tricks to organize data. Each tip helps you work more efficiently and effectively. Discover how to format cells, filter data, and use Excel functions. Learn how to avoid errors and make your work easier. These tricks are great for beginners and advanced users. Start exploring […]
Trick to Copy a sheet to another workbook

How to Copy a Worksheet to Another Workbook in Excel

Did you know you can easily copy a worksheet from one workbook to another in Excel using drag and drop? 😲 In this article, all the tips and tricks to simply this action and save a lot of time in your daily job 😉👍 Steps to Copy a Worksheet to Another Workbook in Excel Why use this method? Copying worksheets between workbooks allows you to transfer data across multiple projects without errors quickly. It saves time by avoiding manual re-entry, ensuring consistency in your data management, and streamlining your workflow for better productivity. The Steps in Video Move a Worksheet to Another Workbook To move a worksheet instead of copying it, just follow the same steps, but do not press the Control key. Related Articles Here are some useful Excel tips and tricks to help improve your data management:
Remove duplicates Excel cover

Remove Duplicates in Excel: Tools and Formulas

Discover three easy ways to remove duplicate values in Excel. Our guide provides simple tools and formulas to streamline your data.
Months in Foreign Language in Excel

Write Months in Any Language in Excel

Discover the trick to displaying months in any language in Excel. Learn how to customize the date format and automate month names in Excel.
Change formula bar font Excel

Change Formula Bar Font Size in Excel

Learn how to make the formula bar font size larger in Excel and improve the readability on high-resolution monitors.
New Excel UI cover

New Excel UI (User Interface)

Experience the new Excel UI in Excel Online. Improve your spreadsheet workflows with the user-friendly interface.
save as Excel online cover

How to do a Save As with Excel Online

Discover how to do a "Save As" in Excel Online. It's possible to change the default folder and assign a new name to your file with ease
Splitting text on a pattern

Splitting a text based on a pattern in Excel

Discover how to split text in Excel using the MID function and an array pattern. Simplify data manipulation and achieve better results.
picto formation 2

Tutorial – Excel Alignment text tips

Discover how to align, wrap, merge cells, and more in Excel. Master these alignment tips to enhance your data presentation and efficiency.
picto formation 1

Tricks to Insert, Delete, Hide Rows and Columns

Efficiently manage columns and rows in Excel with this helpful tutorial. Discover how to insert, delete, and hide columns with the mouse 🧑‍🎓
picto formation 1

Tutorial – Moving cells or columns with the mouse

🧑‍🎓 Master the art of moving and swapping rows and columns in your spreadsheets. Unlock new levels of productivity with these essential tips.
picto formation 1

Tutorial – All Excel tricks to Copy-Paste

🧑‍🎓 Master Excel's copy-paste secrets with this tutorial. Learn how to use fill-handle techniques to enhance your workflow.
ShortCuts Ctrl

Excel Ctrl Key Shortcuts: Boost Your Productivity

Boost your productivity in Excel with Ctrl key shortcuts. With these time-saving tips, you can navigate, format, manipulate data like a pro.
Extract text with AI with Flash Fill

Extract text with AI in Excel with FlashFill

With Excel, you can extract a sub-string without writing formulas with the FlashFill. FlashFill is the first AI tool in Excel
Move cell mouse excel

Move cells with the mouse in Excel (Easy Guide)

Learn how to move cells in Excel with the mouse quickly and easily, step-by-step. This guide is perfect for beginners and experts alike.
Highlight Missing values cover

In Excel, How to highlight missing values?

Become an Excel master with this handy Excel trick to highlight missing values using conditional formatting and no formula.
Meaning of & in Excel

Meaning of the sign & in Excel?

What does mean the sign & in Excel? This sign is very important in many situation to link 2 cells together.
picto formation 1

Tutorial – Adjust the Size of rows and columns

🧑‍🎓 Master Excel: Quick tutorial on adjusting column width for efficient data presentation. Many secrets reveal.
Update data chart automatically

How to Update your chart Series automatically?

Learn the trick to update your chart series automatically when you add new data to your source. No formula is needed.
Find column number in Excel

How to find the column number in Excel?

Learn how to quickly find the column number in Excel using these two easy methods. No more guessing or manual counting!
Calculate without equal sign cover

Excel Trick: Calculate Without the Equal Sign!

Discover the trick to calculate without equal sign in Excel. Simplify your calculations effortlessly with our guide.
Chart with Min and Max

How to display Min and Max in an Excel chart?

How to display the min and the max bars in an Excel chart? This step-by-step guide will explain the technique and it's very simple.
Fill series cover

How to Fill Series Automatically with Excel

Excel can fill series of numbers or dates automatically. Three techniques can be used. Here are the explanations.
Filter for all pivot table columns

Add filter option for all your pivot table columns

Learn the trick to add filter options for all pivot table columns. Enable the Filter menu and access filtering and sorting for every column.
Button to duplicate a conditional formatting

Copy a Conditional formatting rule

You can now copy a conditional formatting rule with Excel 365. This option has been added for Excel 365 only.
function key

Shortcuts – Function Key Excel

The function keys in Excel (or the f key) are very useful and save a lot of time in many situations. Here is the list of the action you can do
How to use filter in Excel

Use Filter for your data in Excel

One of the most useful and powerful tool in Excel is the Filter. It's easy to use and it contains many incredible options.
Cover keep the leading 0 in Excel

How to keep the leading 0 in a cell?

Keep the leading 0 in Excel is important when you want to keep all the digits of your strings and to avoid mistakes
Tips and Tricks Excel worksheet

Tips to Move and Copy Worksheet in Excel

Discover the tips and tricks to move or copy a worksheet in the same workbook or in a new one. All explanations with animated gif.
Fn F9

Audit a Formula with F9

Master the F9 shortcut in Excel to perform formula audits. Quickly analyze each part of your formula to ensure accuracy.
Trick to add slicers in Excel

Add a slicer with Excel Online

Unlock the power of Excel with slicers. Find out how to add a slicer to your Pivot Table and simplify your data filtering process.
Split in sub reports

Split report to many sub-reports automatically

You can split your report to many sub-reports automatically with a pivot table options. When you use the filter, you can spilt your report 😉
Draw borders with your mouse cover

Draw your borders with the mouse

Learn how to draw borders in Excel using just your mouse. Save time and increase precision in your daily tasks.
ShortCuts Alt

Master Excel Navigation with the Alt Key Shortcut

Navigate Excel like a pro with Alt key shortcuts. Access the ribbon interface and execute commands with ease for enhanced efficiency.
Update your drowndown list automatically

Update a Dropdown List automatically

Find out two techniques to create a dynamic dropdown list in Excel by using the power of the Excel Tables. 📌
Paste Special cover

Examples of Paste Special (All Options)

This page illustrates various methods for utilizing Paste Special in Excel, applicable across all Excel versions.

Categories

  • AI & Excel (1)
  • Conditional (12)
  • Conditional Formatting (18)
  • Date (48)
  • Dynamic Arrays (10)
  • Excel Charts (11)
  • Excel Online (4)
  • Excel Tests (8)
  • Excel Training (15)
  • Excel Tutorial (16)
  • Expert (26)
  • Finance (7)
  • Free Excel Tutorial for beginners (29)
  • Function (1)
  • Intermediate Excel Skills: Tutorials and Articles (19)
  • Lookup functions (14)
  • Manage data (18)
  • Maps and GPS (5)
  • Pivot Table (10)
  • Power Query (6)
  • Quiz Premium (7)
  • Shortcuts (5)
  • Statistical functions (25)
  • Text functions (19)
  • Tips and Tricks (21)

Tips and tricks

Remove Gridlines in Excel Easily

Remove gridlines cover

How to Copy a Worksheet to Another Workbook in Excel

Trick to Copy a sheet to another workbook

Remove Duplicates in Excel: Tools and Formulas

Remove duplicates Excel cover

Write Months in Any Language in Excel

Months in Foreign Language in Excel

Change Formula Bar Font Size in Excel

Change formula bar font Excel

New Excel UI (User Interface)

New Excel UI cover

How to do a Save As with Excel Online

save as Excel online cover

Splitting a text based on a pattern in Excel

Splitting text on a pattern

Tutorial – Excel Alignment text tips

picto formation 2

Tricks to Insert, Delete, Hide Rows and Columns

picto formation 1

Tutorial – Moving cells or columns with the mouse

picto formation 1

Tutorial – All Excel tricks to Copy-Paste

picto formation 1

Excel Ctrl Key Shortcuts: Boost Your Productivity

ShortCuts Ctrl

Extract text with AI in Excel with FlashFill

Extract text with AI with Flash Fill

Move cells with the mouse in Excel (Easy Guide)

Move cell mouse excel

In Excel, How to highlight missing values?

Highlight Missing values cover

Meaning of the sign & in Excel?

Meaning of & in Excel

Tutorial – Adjust the Size of rows and columns

picto formation 1

How to Update your chart Series automatically?

Update data chart automatically

How to find the column number in Excel?

Find column number in Excel

Excel Trick: Calculate Without the Equal Sign!

Calculate without equal sign cover

How to display Min and Max in an Excel chart?

Chart with Min and Max

How to Fill Series Automatically with Excel

Fill series cover

Add filter option for all your pivot table columns

Filter for all pivot table columns

Copy a Conditional formatting rule

Button to duplicate a conditional formatting

Shortcuts – Function Key Excel

function key

Use Filter for your data in Excel

How to use filter in Excel

How to keep the leading 0 in a cell?

Cover keep the leading 0 in Excel

Tips to Move and Copy Worksheet in Excel

Tips and Tricks Excel worksheet

Audit a Formula with F9

Fn F9

Add a slicer with Excel Online

Trick to add slicers in Excel

Split report to many sub-reports automatically

Split in sub reports

Draw your borders with the mouse

Draw borders with your mouse cover

Master Excel Navigation with the Alt Key Shortcut

ShortCuts Alt

Update a Dropdown List automatically

Update your drowndown list automatically

Examples of Paste Special (All Options)

Paste Special cover

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net