Microsoft Excel is an extraordinary and widely used spreadsheet program that stores and evaluates data. It has the capability to hold both numerical data and text data. This program has manually and pre-formatted formulas which can be used to calculate numbers.
One of the formulas is the adding of cells or numbers with which you can easily compute multiple cells at one time. You might need to add more cells in your excel sheet, as you start entering your data. Sometimes, you may need to add one column or row and other time you may need to add multiple or columns or rows. If you are new to excel, then you hardly may know about how to add cells in excel.
If you have the large amount of data that you want to present in an impressive way, use Charts. Here is How to Create a Chart in Excel?
No doubt, there are a number of ways to add rows and columns in excel. You can insert single to multiple rows and columns by using mouse or keyboard. With this article, you can become a master of inserting rows and columns in excel. Here are some easy ways to add more rows or columns in excel at the same time.
I am sure these tips and tricks will help you in using excel and put you at ease when it comes to adding up of rows or columns. These tips will let you know to how to add cells in excel with mouse and keyboard use.
So, let’s get this show on the road!
#1. How to Add a Single Row or Column with Mouse
If you are an avid user of mouse that is attached to your system or laptop and then click the right side of the mouse, a box will appear containing many options. Click on the insert option and another box will open and click on the insert a number of rows below the point where you wish to insert a new row.
Here is an example, if you want to insert a blank row between row number 1 and 2, just click right on the 2 number row and click insert in the menu. This will add one row in between row 1 and 2 number row.
Do same when it comes to “how to add columns in excel.” Again click the right on the column letter where you want to insert a new column. For example, if you want to insert a column in between E and F, click right on the F column and click on the insert in the pop-up menu.
#2. How to Add Multiple Row in excel with Mouse
If you want to add multiple rows then drag your mouse gently over a number of rows that you want to insert. A pop-up menu will appear and show you the number of rows which have dragged. With right click on the selected number of rows, again a popup box will appear and click insert. In this way, you will insert multiple rows in excel with the help of Mouse. Don’t know how to add the large numbers in MS Excel, here is How to ‘Add’ in Excel?
#3. How to Add Multiple Columns in Excel with Mouse
As you entered the new multiple rows by dragging number of rows, in the same way, drag with the mouse the number of columns that you want to insert. In the pop-up box that shows selected number of columns click right and click insert. In this way, you will add multiple columns at one time.
Inserting rows and columns with the help of mouse is easy and quick but what would your do if you have to do urgent work on excel which needs editing and inserting of rows or columns? What if your mouse suddenly stops working or you system stop supporting it?
See Also: How to Divide in Excel?
Will you go out to shop for the new mouse instead of having a lack of time in completing your task? In that case, these shortcut keys of adding rows and columns using the keyboard will save you from that situation.
Here are Some Keyboard Shortcut on How to add Cells in Excel
How to Insert a Row in Excel Using the Keyboard
If you love to work on a laptop and are looking for shortcut keys in order to enter a row or column then here are some shortcut keys to insert a row just by tapping one or two keys on the keyboard. These excel insert row shortcut will help you to add single or multiple rows with the use of the keyboard.
To insert a single row, just select the entire row and press Shift + Spacebar keys. Press Ctrl ++ (plus sign) in order to insert a row in excel above the selected row.
How to Insert a Column in Excel Using the Keyboard
If you want to insert a new column then use this shortcut. Press Ctrl + Spacebar and then press Ctrl ++ (plus sign) in order to insert a new column on the left side of a selected row.
How to Insert Multiple Rows Using the Keyboard
To add multiple rows in excel sheet, press Shift + Spacebar. This will select the entire row. Hold the shift button and select the number of rows that you want to add with the help of up or down arrow on the keyboard. Press Ctrl ++ (plus sign) in order to insert the number of new rows. This is the easy way to insert multiple rows in excel using the keyboard.
How to Insert Multiple Columns Using the Keyboard
Select multiple columns by pressing Shift +Space bar. After selection, multiple columns, hold the shift button and with the help of up and down arrow on keyboard, select the number of columns and press Ctrl ++ (plus sign). You will notice that multiple columns will be added at the same time. Charts and Bar graphs are two great ways to represent the data. Here is How to Make a Bar Graph in Excel to make the data look more presentable.
Inserting rows and columns are the most widely used method in the Excel. With this tutorial, you will unlock the potential of using excel. This will give you easy ways “How to add cells in excel” question. As you open Microsoft Excel, you can easily insert rows and columns in the excel. You can also easily delete any row or column as you want. After you add rows or columns in excel, then you can enter your data and save the file.
If you are editing any excel file and have added some rows or columns then make sure you have clicked the save button. This will save your added rows and columns with previous data.
I am sure, you will get a great help from this article and will master over these excel shortcuts of inserting single row or column to multiple row or column.
How To Block Sites on Chrome?
When it comes to surfing the internet, the first browser which strikes through our brain is Google chrome and we have countless reasons for liking chrome. It is really easy to navigate, clean and elegant, fast, its offers a huge number of plugins and extensions and many other. One of such features is the ease to block a website.
Do you know how to block sites on chrome?
Chrome block website feature comes inbuilt and there are several other add-ons which allow us to block websites chrome. We can do it very easily.
In this tutorial, we will be teaching you multiple ways on how to block websites on chrome.
Although, the internet is a great medium to get connected to the world and access tons of information. But unfortunately, there are several unappropriated websites and contents as well, which we don’t want our children or sensitive persons to get access to and the only way we left around is to block such websites.
You can block a website on google chrome if and only if you know how to block a website. Your visit on this page confirms the fact that you need to learn the ways to block a website on chrome. So, without getting fuzzy, let’s head over to the guide!
How To Block Sites On Chrome:
There are multiple ways you can block a website on chrome. The first method by using chrome built-in feature and the other method is by using several website blocking extensions.
We will cover here both the methods.
Method 1. Using google chrome built-in feature:
To block a website using a google chrome built-in feature, you need to create a separate account with limited user authority. For this launch google chrome browser and click the three line on the top right corner and go to Settings. Now click on Add person under People.
In the Add person pop-up window, Name the person whatever you like to, Check the option “Control and view the websites this person visits” and click Add. The account to be supervised will be created immediately and you can have access to it by signing in to your google account
To block a website, log in to your google account by entering the credentials. After that, go to Manage> Permissions. Now do the needful changes there i.e entering the website URL you want to block and apply the changes.
You will get to know all the settings once you visit supervised user dashboard! Now let your child access this account with limited access to the website and keep them secure from inappropriate contents.
Method 2. Using Extensions:
If you want an easier way to blocking a website and creating a supervised account doesn’t seem a good choice to you, then use the below-mentioned steps and get your job done faster than ever.
This method will show you how can we block a website on chrome using different extensions.
SiteBlock is one the best extensions for blocking a website. Blocking a website via site block is extremely easy. You can block a website and show a static page or can redirect it to another website you want.
You can set one redirect website for all the blocked websites or separate website for individual pages. This way you can not only block a website but can have a full control over what website should your children visit and what not by redirecting them to some relevant page.
To block a website on chrome using this extension, Open chrome browser and go to Settings> More Tools> Extensions Or simply go to this URL chrome://extensions.
On the extensions page, scroll down and click “Get more extensions” link. Now search Site Block there and install it on your chrome browser. Once the extension is installed, just visit the website you want to block, right-click anywhere on the page and go to Block Site and select Add Current Site to Blacklist.
You can even directly block a website from the app itself without even visiting the website. Moreover, this extension lets you set the time intervals and days on which you want to block this website for.
Another great feature offered by ‘Site Block’ extension is password protection. One of the basic reasons for blocking a website is to protect children from accessing adult and inappropriate websites. When you install this extension or any other extension for blocking a website, chances are for this extension to get uninstalled by your children or any other member of your family.
Hence, password protection is a feature which comes out really handy. You can easily password protect this extension and can have more control over the websites and the extension.
Another extension for blocking a website is Stay focused. It is one of the great alternatives for Site Block and helps you block a website in extremely easy steps. I won’t teach you how to use this extension because once you’ll install it on your chrome browser, you won’t need anyone’s help to deal with it.
Nanny is an advanced extension for chrome users which lets you keep track of the hours you spent on a particular website. Also, it blocks a particular web site after the time duration you have set on this extension.
It cares for you as a nanny and keeps you focused while working. Because we all want to concentrate more on work but not on social websites like facebook and twitter. But unknowingly we do just opposite of it and spend hours unaware of the time wastage.
This extension not only helps you but you can also keep track of your child’s activity.
These are just three extensions I mentioned. There are many other dedicated google chrome extensions which offered the same service of blocking a website.
Just remember, learning how to block sites on chrome is really important. If you don’t use this feature now, probably you’ll need it in the future. Because the Internet is surely a blessing to humans but at the same time, it is highly risky for children and sensitive people. It’s full of inappropriate contents which should not be accessed by delicate souls.
So with this, I’m wrapping of this tutorial, you can leave your comments below in the case of any doubt.
How to Speed Up Windows 7 Performance
No matter how fast your new computers might be, they all seem to get slower over time. Because there is a new kind of excitement to play with a new computer and to install lots of software on it.
The first program which we install on our new computers is anti-spyware and antivirus tools, to stay from viruses. I know, it’s an essential program but what we actually do, we install more than one antivirus program.
Next, we download lots of unrecognized junk software from the internet. Obviously, your new computers gradually decrease the performance and one day when you are trying to open a program or file then it takes more time to open up.
So, Whatever the cause, there are lots of ways to speed up Windows 7 performance and make your PC work better without upgrading your hardware. Here are something that will help you in installing Windows 7 custom themes.
Tips to Speed Up Windows 7 Performance
Turn Transparency Off
The glass transparency uses more resources of a PC from the Aero feature, you can disable by following simple steps.
Step 1: Go to personalize. (Right Click on desktop > Personalize)
Step 2: Click on the Window Color icon at the bottom of window.
Step 3: Uncheck the box to disable transparency.
Step 4: Click on save changes.
This will save some resources from being utilized and Speed Up Windows 7 Performance.
Turn on only required Visual Effects
You have to turn on only those visual effects that are essential and required by you. You can optimize how menus and windows appear by following simple steps.
Step 1: Open My Computer > Click on System Properties >Click on Advanced system settings (left hand side).
Step 2: A small window will open up and from there go to the advanced tab and click on settings (performance).
Step 3: Now here you can go for any of one option.
Option 1: Click on checkboxes as shown in the image below.
Option 2: Select (dot) “Let Windows choose what’s best for my computer“
Step 4: Click on Apply.
Enable Writing Cache for Storage Devices
This option will tweak your storage devices such as internal disks or removal drive to give the highest possible performance, to enable just you need to follow the below simple steps.
Step 1: Open Device Manager (Right Click on icon My Computer > Click on Manage)
Step 2: In Device Manager, click on disk drives to expand the attached drives to your computer. Here I have two drives, one is the internal hard disk and second is pendrive.
Step 3: Firstly, double-click on internal hard disk > Click on Policies tab > Check Enable writing cache on the device > Click Ok
Step 4: Now, click on another drive (pendrive) > Click on Policies tab > Select (dot) Better Performance > Click Ok
This will surely optimize the usage of cache memory and Speed Up Windows 7 Performance.
Turn off unnecessary Windows Features
Windows 7 comes with lots of features and we all know that we are not using all the features of it so it also allows us to turn on or off Windows features as per our requirement. That will also speed up the startup process for windows 7. For that, just follow the below simple steps.
Step 1: Open the Start Menu, type Windows Features in the search box, and press Enter.
Step 2: Open up “Turn Windows Features On or Off” icon. In that, if you want to turn on any features then tick the check box otherwise untick the check box to disable the features.
Step 3: After turning on or off, you will have to restart your PC. That’s it.
Helps in reducing unnecessary usage of CPU and Speed Up Windows 7 Performance.
Disable GUI Boot
Disabling GUI boot literally reduces the startup time of Windows 7. Follow the simple steps to Increase Startup Speed Windows 7.
Step 1: Open Command Prompt (Win Key + R) > type “msconfig” > Enter.
Step 2: Click on the boot tab > Select your OS (Ex: I nave Windows 7). Then, below you will see many options from that check the box of “No GUI boot” and “Make all boot settings permanent” > Click Ok. I will ask for confirmation click yes and restart.
So, all these are the important tips to Speed Up Windows 7 Performance. If you have any problem or query regarding this then you can surely put your comments below and we will connect with you as soon as possible! Happy Tweaking 😀
How To Create QR Codes In Easy Steps
In this technology-infused era, everyone wants to have an edge over others. For this, expeditiousness and use of trending technology is a must. Gone are those days when we used to stick to a particular technology for a long period of time.
With the serial advancement, first came the technology of Bar Codes which was derived from the concept of storing some sort of quick information or data in a flat piece. Then came the successor of Bar Codes, QR code (a two-dimensional Bar Code) with some great features.
QR codes facilitated us with the facility of storing data that is very often used such as name, address, contact details, certain URL’s, social media profiles and much more, all confined in a square grid comprising of certain standardized patterns.
See Also: How to Find People on Snapchat
QR codes have revolutionized the way that information is being transfered.
So, let’s dig a little deeper and find out what are QR codes and How to create QR codes in easy steps.
What is a QR code?
Quick Response codes, often abbreviated as QR codes are a kind of matrix Bar Code or two-dimensional Bar Codes (a machine-readable code represented in the form of patterns of parallel lines and numbers usually used to store information’s like price, index of an object to which it is attached ).
QR codes came to us all the way from the technological hub Japan where they were first designed for the automotive Industry.
A QR code uses four industry standard encoding modes to efficiently store information about the item to which it is attached and those are: Numeric, Alphanumeric, Byte/Binary and Kanji (漢字 logographic Chinese character).
A QR code consists of Square dots (black modules) systematically arranged in a square box with a white background and can be read by imaging devices like scanner or camera.
Fact: the QR code system was invented in 1994 by Denso wave (a subsidiary of Toyota) with the sole purpose of tracking vehicles during manufacture. QR codes can store more than 4,000 alphanumeric characters in a limited space.
What purpose are QR codes used for?
QR codes are quite popular in the industry because of its quick readability and larger storage capacity as compared to the usual Bar Codes.
#1: QR codes can be used to link directly to a URL
#2: QR codes can be used to store data like name, address, numeric values like price, phone numbers etc.
#1: One can add QR codes to his/her business cards that could store name, address, contact numbers, links to the social media presence.
#2: QR codes are quite often used in product packaging.
#3: QR codes can be used in print advertisements to boost reach and earnings.
How to create QR codes in easy steps?
See Also: How to Make Emoticons for Facebook?
If you will follow these steps carefully then you will get to know how to create QR codes easily.
Step #1: Search for an online QR code generator. If you will Google it by the keyword “QR code generator”, you will find a plethora of them. Some of them are QRstuff and the QRcode generator. For the sake of instance and simplicity, we will be using QRstuff at first.
Step #2: Select the Data Type (basically the type of information you wanted to convey through the QR code) of the QR code. You can choose from various options like: Website URL, YouTube Video, contact details etc.
Step #3: Type in the details corresponding to the data type which you have chosen.
Step #4: Select the type of color of the QR code. You can select your desired color from the user-friendly multi-color swatch.
QRstuff also facilitates the user to have a preview of the QR code which has been created.
Step #4: Download the QR code. It equips you with the PNG file of the QR code. Moreover, one can even print and E-mail the QR code directly from the website itself.
QR codes created by these methods will work perfectly fine but going with the paid platforms obviously has its perks, here we list some of those perks:
1: you can edit the content without playing with the design of the QR code.
2: you can have multi-user accessibility for managing QR code campaigns.
3: you will be equipped with the facility of tracking the number of scans corresponding to the geography, device and time.
4: you can have the desired resolution, scalar or vector image, format, and quality.
Alternatively, one can also use software for creating QR codes easily.
QR codes work like a charm, You have to see it to believe it. Hope we are efficient enough to make you aware of the basics you need to know while creating you first QR code.
If you have any query regarding QR codes, do let us know via comments. We’ll surely get back to you and will try our level best to solve your thing.
If this piece added some worthwhile value to your knowledge base, then don’t forget to show your appreciation. Do share it on your social media profiles. Thank you for the same in advance.
How to use BitLocker to Encrypt your Files
Locker means a safe place where you can put your personal or important things hiding from others. We all have some things which we don’t want to share with others same as in the computer you have any important data that you want to hide from the outside world. For that, there are many software available over the web and as well as well-known by you so no need to describe it.
But if you want to lock your Hard Drive partitions without any software then? In that case, Microsoft has provided one wonderful tool known as “BitLocker” in Windows Vista, 7 and 8 for encrypting your entire Hard Drive partitions. Using BitLocker you can lock any volume on the computer even the one you boot from. But a question arises in your mind that How to use it, right? So, I will show you two different modes to use BitLocker on your computer. If you wanted to Defrag the Hard Drive, you should see that.
1. “How to use BitLocker on a normal/data volume”
2. “How to use BitLocker on Boot volume”
Let’s see the first mode:
1. How to use BitLocker on a normal/data volume?
A simple way to enable BitLocker – right click on any volume and select “Turn BitLocker on” to start the locking process. After clicking a window will pop-up (as shown in the figure below) asking to enter a password to use with the drive – you will also ask to say a copy of the recovery key somewhere at safe place and then it will begin encrypting your drive.
By this method you can lock all the drives on your computer except “C:/ drive” or “Boot partition”.
Now, the second mode:
2. How to use BitLocker on Boot volume
Yes, it is true that you can encrypt the main operating system drive, but this has some special requirements since the drive has to be unlocked before boot. First of all this requires that Windows has a seperate boot partition that isn’t encrypted; in case if you don’t have then create a separate boot partition. The second requirement is that your system include a TPM (Trusted Platform Module).
If you try to encrypt your boot volume without satisfying the above to requirement then it will give an error as shown in the figure below.
So, in that case you will need to configure your system to use BitLocker with a TPM. Here is how you can do that.
- Press [win + r] and type “gpedit.msc” in it and press enter to launch the Local Group Policy Editor
- Now, browse to – “Computer Configuration > Administrator Templates > Windows Components > BitLocker Frive Encryption > Operating System Drives
- In the right panel. double click the setting “Require additional authentication at startup” and select “Enabled”
- In that please check the below options that “Allow BitLocker without a compatible TPM…” is checked.
- Then, Click Ok – you are done.
Now you will able to start the BitLocker process on your system drive, and will have the option to either enter a password on startup or insert a USB drive to boot.
If you have any problem regarding “BitLocker” then put your comments below so that I can surely help you to get rid out of your problem. Hope this guide helped you to understand how to use BitLocker.
PC taking more startup time? Change the Startup program to boost the startup process in windows 7.
How To Test Wifi Speed?
As we all know, in this modern generation Internet has become as important as water and oxygen. Without the internet one’s life is boring like a lazy sloth. The Internet helps us to connect with the world. And needless to say, a simple source of internet is a WiFi.
WiFi, i.e. wireless fidelity, which provides a wireless connection to the internet in a particular area. Users can connect to it from their Android devices and laptops just by putting the required key and can enjoy the benefits. It is really annoying when your WiFi speed works like a snail, and I can understand that feeling since I am also a regular user of wifi.
But don’t worry you can anytime upgrade your connections to enhance the speed. But before that, you will need to check the actual speed whether it’s actually slow or its just a network problem. In this article, we are gonna show you how to test WiFi speed. Follow the guide and learn to check WiFi speed just by following few steps.
How To Test WiFi Speed:-
#Method 1. By Using Third Party Websites
First of all, you can use the OOKLA speed test website. The OOKLA is one of the best and true websites for checking the speed of your wireless connection of internet. This website is very easy to use and can give the results faster than any other website. But remember, to use this website you will need a software called adobe flash player.
If you don’t have adobe flash player you won’t be able to use this trick and you will have to drop the idea of using OOKLA and have to try out other methods which I’ve shown below in the guide. To use OOKLA speed test track, you have to go to the website http://www.speedtest.net.
As sooner you visit the website, you will see an awesome background and a laptop type structure in which a world map is shown and a meter which shows your internet speed. Now just click on the big green button of Begin Test and it will select the best server based on ping.
After that, it will test your download speed, you just need to wait for a few seconds. Once the test is complete, you will get notified about your download speed.
After the downloading speed check is complete, the OOKLA will test for your uploading speed and again in a few seconds, it will show your uploading speed. My internet is too slow as you can see in the image 😛
This is an awesome website to check the speed of wifi, whether it’s downloading or uploading speed. And if it is not working fine on your Pc or doesn’t support to your device, then here is another good website which is also powered by OOKLA speed test.
The other website for speed test wifi is http://www.timewarnercable.com/en/support/speed-test.html. Just click on the above link and you will land on the new page of Time Warner Cable website of testing the speed of your internet.
To use this, just click on the Begin Test button and wait for a few seconds.
And it will show you the download speed and upload speed as well.
OOKLA is the best software for checking the speed of your WiFi. I think you don’t need any other way to check your wi-fi speed, but as I promised above, let’s check out the method to check wi-fi speed without any website.
#Method 2. Without Using Any Websites
We can check our internet speed without any software or any website within our computer or laptop. Just follow these simple steps. But remember, the method I’m showing you is applicable for windows 7 users or above.
If you are using Windows XP then stay tuned, I will show the method to check the internet speed on Windows XP too.
Following are the steps to check network speed on windows 7, just keep calm and follow these simple steps:-
Step 1. First of all, you need to go to Control Panel.
Step 2. Open Network and Sharing Center as shown in the below-given image.
Now a new window will open up with the details about your internet connection. Under View your active networks section, there are three options:_
: Access type:
You can see in the connection section, a cable icon is shown which means my internet is connected through a cable.
Step 3. The next step is to click on the option which is shown in the connection section like mine is Local Area Connection.
After clicking on that, a new pop-up window will open up with all the details about your connections. You can see the below screenshot in case of any doubt.
You can see the fifth point ‘Speed’ which means with how much speed your internet is running. I think you are shocked by watching my speed (100.0 Mbps)!! Guys don’t worry, it happened because I am using the internet by cable but it will show the real speed when you are connected with WiFi.
Now for the Windows XP users, if you want to check the speed of your wifi without any website and any software, stay tuned and read the next few simple steps, I think they might be helpful to you 🙂
Step 1. Go to start menu and open Control Panel.
Step 2. Then select Network Connections as shown in the given image.
Step 3. Now under LAN or High-Speed Internet section, two computers and a cable-type structure are shown, just double click on that.
And again a dialog box will pop-up and under the connection section, you can see the speed of your internet connection.
That’s all for the guide!!
We hope the tutorial helped you learn how to test wifi speed. Now you can perform wifi speed test without taking any one’s help!
There are many other websites and software to check the speed of the internet which you can get by searching on google and if you want to check your internet speed on android, there are many apps for that too!
You just have to search it on google and You’ll be provided with several such apps and websites.
How To Block Sites on Chrome?
How to Start a Blog for Free?
How to Tell What Version iPhone You Have?
How to Solve Yahoo Mail not Working?
How to Reset Macbook Air?
How to Use Apple Thunderbolt Display with PC?
Tech1 week ago
How to Solve Yahoo Mail not Working?
Computers2 weeks ago
How to Reset Macbook Air?
Mac2 days ago
How to Use Apple Thunderbolt Display with PC?
Tech1 week ago
How to Make a Yahoo Account Without a Phone Number?
iOS2 weeks ago
How to Stream Torrents on iPhone?
Tech1 week ago
How to Tame a Horse in Minecraft?
Tech1 week ago
How to Receive Money through PayPal?
Windows2 weeks ago
How to check RAM type (DDR, DDR2 or DDR3) in Windows?