Excel Tips

Create and open a new Excel workbook

How to create and open a new Excel workbook? What is the Excel spreadsheet? Excel is a software from the Microsoft Office suite. An Excel file is also called an Excel workbook. Like a traditional physical workbook, it consists of sheets but also tables and cells. First of all, the Excel sheets are actually tabs. Tables and lists can be created. These tables and

Excel Tips

The best Excel shortcuts for selection

f_page – top_of_page –>What are the best Excel selection shortcuts? Excel is a very powerful software tool and the most used spreadsheet program in the world by far. Nowadays everyone uses Excel in their daily work. However, many of the most effective Excel shortcuts for making selections are still little known. Here are the best Excel shortcuts in a series of articles. This selection

Excel Tips

Shortcut to select an entire Excel column

How to select an entire Excel column with data all the way down from the top the end? Use a keyboard shortcut to select an entire Excel column with data. This Excel shortcut works with a table and will stop at the last line of the table. It also works with data that is not inside a table. It will detect the filled lines

Excel Tips

Open two Excel files in separate windows

How to open two Excel files in separate windows at the same time? Open two Excel files in separate windows seems easy, yet by default, Windows 10 opens both files in the same software, i.e. Excel 2016. So you have to navigate between the files, but can’t see them at the same time. It is therefore useful to have two windows, or even better,

days of calendar
Excel Tips

Split Excel date and time in two columns

How to split date and time in two columns with Excel? Splitting a date from the time with Excel is not as simple as that. We will see how to do it with a practical example in Excel. Indeed, often when working with Excel, the Dates columns contain in practice the “Timestamp” format which corresponds in French to the “Date-Heure” format. However, to perform

Excel Tips

Excel day of the week in all letters from a date

How to display the Excel day of the week from a date with a formula? With the Excel software, it is more convenient to display the Excel day of the week rather than the date in a numeric Date format. Indeed, when using dates with Microsoft Office and especially Excel to manage statistics and schedules tables, readability is important. So, how to display Excel

Excel Tips

Turn off Excel scroll lock

How to turn off the scroll lock in Excel and move the cursor from cell to cell? Tip on how to turn off the scroll lock mode in Excel, that makes the Excel file move instead of the cursor with the keyboard directional arrows. Indeed, pressing the directional arrows on the keyboard does nothing, the cell remains locked but the Excel spreadsheet moves around