Excel

How to Insert Pictures in Excel

February 11, 2023 by Admin Leave a Comment

Excel is a powerful tool for organising and analysing data, but sometimes you need to add a visual touch to your spreadsheets. Whether it’s for a presentation, a report, or simply to make your data easier to understand, inserting pictures in Excel is a useful skill to have. In this blog post, we’ll show you how to insert pictures in Excel and provide tips for formatting and positioning them.

Step 1: Select the Cell The first step in inserting a picture in Excel is to select the cell where you want the picture to appear. This will ensure that the picture stays in place and doesn’t move as you make changes to the spreadsheet.

Step 2: Insert Picture Once you’ve selected the cell, go to the “Insert” tab and click “Picture.” You can then select the picture you want to insert from your computer or from a file on your network.

Step 3: Resize and Format Once you’ve inserted the picture, you can resize it to fit the cell or the entire spreadsheet. To do this, click and drag the edges of the picture until it’s the size you want. You can also use the “Format Picture” option to adjust the picture’s brightness, contrast, and other attributes like Fill & Line, Effects, Size and Properties

By following these steps, you’ll be able to easily insert pictures into your Excel spreadsheets and add a visual touch to your data. Whether you’re creating a presentation, a report, or simply organising your data, adding pictures in Excel is a useful skill to have.

Streamline your Excel spreadsheets with these easy steps to hide rows and columns

February 4, 2023 by Admin Leave a Comment

Excel spreadsheets can get cluttered and disorganised with too much data, making it difficult to find what you need. Hiding rows and columns in Excel can be a simple solution to keep your data organised and easily accessible.

Steps to Hide Rows and Columns:

Select the rows or columns you want to hide. To select multiple rows or columns, hold down the “Ctrl” key (Windows) or “Cmd” key (Mac) while clicking on each row or column.
Right-click on the selected rows or columns and select “Hide”.

To unhide the rows or columns, select the rows or columns immediately above or to the left of the hidden ones.
Right-click and select “Unhide”.

Another way to hide rows and columns is to use the “Format” dropdown menu on the Home tab. Simply select the rows or columns you want to hide, then go to Home > Format > Hide & Unhide > Hide Rows or Hide Columns.

Format Menu - Hide or Unhide Rows and Columns in Excel

Benefits of hiding rows and columns:

Keeps your spreadsheet organised and easier to navigate
Helps to focus on relevant data and minimise clutter
Protects sensitive data by making it invisible
Doesn’t delete the data, only makes it invisible, so it can still be used in formulas and calculations

You can also check out the steps for hiding rows and column headers in excel and Search, hide, print comments in Excel

How to display fractions in Excel

December 17, 2022 by Admin Leave a Comment

In excel when we type fractions like ‘1/2’, ‘1/3’, it shows dates like 01-Feb, 01-Mar. To display fractions and stop converting in to dates you can follow the below mentioned steps.

Select the cells or columns where you want the fractions to appear.

Right click and select Format Cells option

Under the Number tab select Fraction.
Select the type of fraction you want. For this example we are going with ‘Up to one digit’. Click Ok to save the changes.

You might be interested in this post as well – Disable conversion numbers with dash to dates in Excel

How to Separate a Person’s First and Last Name in Excel

December 11, 2022 by Admin Leave a Comment

Here are the formulas for separating first name and last name from a person’s full name. Let us take the following sample data of NBA players

Separate First name and Last Name

Let us first start separating First Name from the Player’s name. Type the this formula in C6 Cell.

=LEFT(B6,FIND(” “,B6))

The above formula first finds the single space then Left trims character starting from first character until the start of the single space. Now Autofill this formula for the rest of C6 columns to display the first name.

To get the last name of LeBron James (Cell B6) you can use this formula

=RIGHT(B6,LEN(B6)-FIND(” “,B6) )

What the above formula does is to first get the character count of full name then find starting position of ” “. Then uses RIGHT function to get the characters starting from ” ” till the end of the name. Now drag the formula entered for D6 to rest of the D column.

How to disable auto fill feature in Excel

November 9, 2015 by Admin 15 Comments

Auto fill in excel is quite handy feature, using this you can fill series of cells based on the entries of other excel cells. But if you want to turn off or disable auto fill feature then you can use Excel options for doing this. Listed below are the steps to turn off auto fill in Excel 2013, Excel 2010 and Excel 2007

Excel 2016, 2013 and 2010

Click on the File menu –> Options link and navigate to Advanced tab on the left hand side.

Under Editing options, un tick the check box with label as Enable fill handle and cell drag-and-drop. This will turn off the auto fill feature in Excel 2010.

Excel 2007

In Excel 2007, this feature can be turned on or off using the Excel Advanced Options.

Click on the Office button –> Excel Options

Under Excel Options select Advanced section

By checking or un checking “Enable fill handle and cell drag-and-drop”, you can turn on or off the Auto fill feature in Excel 2007.

Also See: How to disable autocomplete suggestion feature in Excel 2010

How to change the decimal separator in Microsoft Excel

November 1, 2014 by Admin 15 Comments

Microsoft Excel 2013 and 2010 by default uses the system defined decimal separator. In Windows 8 and Windows 7 this option is defined under the Regional and Language Settings available under Control Panel.

Step 1: Right click on the bottom end corner of Window 8 system and select Control Panel from the menu list (In Windows 7, navigate to Control Panel).

Step 2: In Adjust your computer’s settings screen, click Clock, Language and Region option.

Step 3: In Clock, Language and Region screen, click Change date, time or number formats under Region section.

Step 4: Click the Additional settings button in the Region window.

Step 5: In Customise Format window, enter the new separator for Decimal Symbol. Then click Apply and Ok button to save the changes.

Microsoft Excel also provides users can customize the separator used for Decimals and Thousands using Excel Options. Listed below are the steps to change decimal separator in Excel 2013 and Excel 2010

Step 1: Click File menu and select Options from the menu list.

Step 2: In the Options screen, click the Advanced tab and navigate to Editing section.

Step 3: Under Editing section, un mark the check box with caption as “User system separators”.

Step 4: Now enter your new decimal separator under Decimal separator field. For this demo we are colon (:) as the decimal separator.

Step 5: Click OK to confirm and save the changes.

Also See: How to change decimal separator on Mac OS X Lion