Recent Posts


Various Copy Functions in Excel

Bagikan ke:
To copy a cell in Excel normally use the copy function is to right click and copy. Can be a shortcut Ctrl + C to copy it. But the copy function in Microsoft Excel there are manifold. That does not just copy the active cell with Ctrl + C, but there are various copy functions in Excel.

Copy Function in Excel

Copy the active cell in Microsoft Excel by using the copy function is very simple but quite important. Standard function that is used to copy the active cell in Microsoft Excel is to use a mouse and keyboard. Here's how to copy the active cell in Microsoft Excel:
  1. Select the active cell to be copied
  2. Right-click on the mouse and select "Copy"
In addition to the above could also use a shortcut:
  1. Select the active cell to be copied
  2. Press Ctrl on the keyboard, at the same time press the letter C is also key, so that is pressed Ctrl + C simultaneously.

Copying Cells Excel into a Picture

Normally, cells that have been copied normally be displayed in the same form. This means that if a cell contains text, then copy the results also in the form of writing. It turns out that there is also a Microsoft Excel function "Copy as Picture". The function "Copy as Picture" is used to copy the active cell in Excel and displayed (paste) into an image. Whatever the contents of the cell to copy, will be displayed in an image. How:
  1. Select the active cell to be copied
  2. Select the menu bar "home" and find the function button "Copy".
  3. Select "Copy as Picture" 
  4. Display Cells were copied
  5. How to display the cell that you copied above (paste) is as follows:
  6. Right-click on the new cell
  7. Choose "paste"
Or it could be by pressing Ctrl + V, which means that the Ctrl key is pressed simultaneously with the letter V button on the new cell.

Paste Function in Microsoft Excel

Paste functions are also diverse. After you copy the cell, then you must display the function "paste". Here is the function "paste" that exist in Microsoft Excel:
  1. Paste (P)
  2. Value (V)
  3. Formulas (F)
  4. Transpose (T)
  5. Formatting (R)
  6. Paste Link (N)
  7. Paste Special others.

How to Protect Cells Excel Sheet with Password

Bagikan ke:
We can Protect Cells Excel Sheet with Password we want when the sheet is considered privacy and should not be changed at all by others. Typically this function is used on a computer that is connected to a LAN (Local Area Networking) where multiple computers can access the file simultaneously.
Protected section is a cell in a Microsoft Excel worksheet, not on the Excel Workbook. To protect the workbook in Microsoft Excel will be discussed separately in another article on this site.

How to Protect Cells Excel Sheet with Password

The following are steps you can do to Protect Cells Excel Sheet Password:
  1. Open the Microsoft Excel spreadsheet (Excel sheet) would you give the password
  2. Hover your mouse cursor on the menu bar, then select Review
  3. Note the area of the menu bar, you will find a function "Protect Sheet", select the function "Protect Sheet" 
  4. Checking the "select locked cells" and "select unlocked cells"
  5. Fill in the password to your liking in the "Password to unprotect sheet"
  6. select Ok
  7. Fill in the password above on "Reenter password to proceed"
  8. Select Ok. finished
  9. You have successfully Protect Cells Excel Sheet with Password.

After successfully Protect Cells Excel Sheet with password, do not you ever forget a password that you use. This is very important, because if you forget it then you will face difficulties to protect an Excel sheet that you actually addressed to someone else.

Note: To remove protection Excel (remove password protection) sheet, you can do it like the above, but you have to fill in the password that you have previously input.

Microsoft Excel keyboard shortcuts

Bagikan ke:
Shortcut Microsoft Excel is a key on the keyboard which consists of one or a combination of two key keyboard that can perform the functions of the Microsoft Excel application.

Microsoft Excel keyboard shortcuts

Shortcuts in Microsoft Excel is used to facilitate our work in using Microsoft Excel. So, to carry out basic functions in Microsoft Excel can be done simply by pressing a certain key on the keyboard on your computer. Surely you have to memorize the shortcuts to be more efficient in its use. To further speed up work on Ms. Excel we can use some shortcuts in Microsoft Excel as below:

Action Keystroke
Document actions
Open a file CTRL+O
New file CTRL+N
Save As F12
Save CTRL+S
Print CTRL+P
Find CTRL+F
Replace CTRL+H
Go to F5
Cursor Movement
One cell up up arrow
One cell down down arrow
One cell right Tab
One cell left SHIFT+Tab
Top of worksheet (cell A1) CTRL+Home
End of worksheet(last cell with data) CTRL+End
End of row Home
End of column CTRL+left arrow
Move to next worksheet CTRL+PageDown
Formulas
Apply AutoSum ALT+=
Current date CTRL+;
Current time CTRL+:
Spelling F7
Help F1
Macros ALT+F8

Microsoft Excel keyboard shortcuts

Action Keystroke
Selecting Cells
All cells left of current cell SHIFT+left arrow
All cells right of current cell SHIFT+right arrow
Entire column CTRL+Spacebar
Entire row SHIFT+Spacebar
Entire worksheet CTRL+A
Text Style
Bold CTRL+B
Italics CTRL+I
Underline CTRL+U
Strikethrough CTRL+5
Formatting
Edit active cell F2
Format as currency with 2 decimal places SHIFT+CTRL+$
Format as percent with no decimal places SHIFT+CTRL+%
Cut CTRL+X
Copy CTRL+C
Paste CTRL+V
Undo CTRL+Z
Redo CTRL+Y
Format cells dialog box CTRL+1

How to Protect a Microsoft Excel file with a password

Bagikan ke:
Office files that we created in MS Excel files can sometimes be important for us and should not be viewed or modified by others. To protect these files we can put a password on the file Ms. Excel. By doing protection of important files on the computer will prevent data damage and also to secure the file.

Steps to Create a Password in Ms. Excel

Create a password in the file Office Ms. Excel is actually very easy. The following describes about How to Protect Microsoft Excel files with a password. Here are the steps:

  1. Open the file that will be protected with a password and then click Save As
  2. Click on "Tools" on the bottom and then select the "General Options""
  3. Enter a password to protect the file office. Password to open you must enter if you want the file can not be opened without specifying a password. Passwords to modify you must enter if you want the file can not be modified without writing down the password (the file can be opened but can not be modified). The password is then used to open a file or modify files that have been protected.
  4. File Office Ms. Word and Ms. Excel has successfully protected

By doing all of the above steps, you've managed to do tips on How to Protect a Microsoft Excel file with a password.

How to make a table in Microsoft Excel

Bagikan ke:
Creating a table in Microsoft Excel is one of the basic techniques that must be mastered if you work with Excel. Working on school assignments, coursework or work that requires Excel to complete the application, you must know the basic techniques How to make a table in Microsoft Excel. Actually very simple and easy to create a table in Microsoft Excel, but for us who have not been using Microsoft Excel may not know how to create the table.

How to create a table in Microsoft Excel

Steps to create a table in Microsoft Excel is as follows:
  1. Open the Microsoft Excel application
  2. Select the cells that you want to give the table
  3. Select the table button in the menu bar (home). To select a table with different thickness and appearance select more border.
  4. Finish

Add and Delete Columns and Rows in Excel

Bagikan ke:
Add and Delete Columns and Rows in Excel - Sometimes we need additional rows and columns in an excel worksheet that we use. Likewise, when certain emerging desire to remove some of the columns and rows in Excel. And it turns out how to add and delete columns and rows in Excel is very easy, even without reading the article even this fact you may already be. Only by using the click of a mouse on your computer.

Adding Rows and Columns

ADD ROW

  1. To insert a row into the spreadsheet with the mouse pointer, right click on the header row below where you want the new row is added.
  2. Select "Insert"
  3. The new line will be inserted at the top of the line that you choose.
  4. To add more than one new row, select more than one line in the header row.
  5. On the header row, pull the number of lines to be added to the spreadsheet.
  6. Right-click on the selected row.
  7. Select Insert from the menu.
  8. The new line will be inserted at the top of the first line that you select.

ADD COLUMN

  1. To add a column to the spreadsheet with the mouse pointer, right click on the column header where you want the new column is added.
  2. Select "Insert"
  3. The new column will be inserted to the left of the selected column.
  4. To add more than one new column, we select more than one column in the column header.
  5. In the column header, drag select the number of columns you want to add to the spreadsheet.
  6. Right-click on the selected column.
  7. Select "Insert"
  8. The new column will be inserted to the left of the selected column.

Deleting Rows and Columns

Before you remove, it is important to note that any data that is located in the deleted row or column, will be deleted as well. If you make a mistake, use the Undo from the Edit menu to get your data back or by pressing Ctrl + Z.
  1. To delete a row from a spreadsheet, right-click on the row header row you want to delete and then select "Delete"
  2. To remove a few rows of the spreadsheet In the header row, select the row you want to delete. Right-click on the selected row, and then select Delete.
  3. To delete a column of the spreadsheet, right click on the column you want to delete. Select Delete.
  4. To remove some of the columns of a spreadsheet, In the column header, select the column you want to delete. Right-click on the selected column. Select Delete.

What changes occur

When you add or delete columns or rows, the cell references in functions and formulas will usually update automatically. For example, if you have a cell reference in the formula A11 and then add a line at the top of this, the formula will change the reference from A11 to A12 to reflect the fact that the line 11 is driven down into 12 rows after a new row is added.

How to Change Column Width and Row Height in Excel

Bagikan ke:
How to Change Column Width and Row Height in Excel? In Microsoft Excel Spreadsheets worksheet, you can change the column width or height of rows in the worksheet to improve the readability and appearance of data. For example, if a worksheet contains a lot of numbers, you can expand the column to make the worksheet more tidy. You should always extend a column that contains cells with text or number entry (shown) is cut off in an Excel worksheet.
Based on the standard font Calibri size 11, the default column width is 8.43 and the standard line height is 15. If you change the font type and size standard, Excel also can change the column width or height alone standard line.

Adjust the column width

Follow the steps below to adjust the column width (change column widths in excel):

  1. Select the column whose width you want to change. Select multiple columns if you want more than one column to be changed.
  2. Click the letters column. If you want to set one column, click a cell in the column. For example, column A or column B, and so on.
  3. To manually change the column width, position the mouse pointer on the boundary between one column to another column until it turns into a double-sided arrow. For example, to change the width of column A, then click on the line that constitutes the border with column B. Pull up the width of the column you want.
  4. To change the column width automatically and with regular size, click on the column (eg: click column A).
  5. Then right click and select "Column Width".
  6. Fill in the numbers that would be the width of the column.

Change the row height

To change the height of one or more lines, follow these steps:

  1. Select the row that you want to adjust the height.
  2. To select an entire row, click on the row number on the left. If you want to set up one row, click the cell in the row.
  3. To manually change the row height, position the mouse pointer on the lower boundary line of the title until it turns into a double-sided arrow. Pull until the row is the height you want.
  4. To change the line width automatically and with regular size, click on the line (eg: click column A).
  5. Then right click and select "Row Height".
  6. Fill in the numbers that would be the line width.


Random Artikel Menu: