Saturday, August 10, 2013
Microsoft Excel tricks during homework or statistics
1. In Excel can do is hide behind the pages of text (watermark) in Word as possible?
In Excel Watermark functionality is not available but you can also do the following
1.Bam menu View -> press select Header and Footer
2.Hop open the Page Setup -> you click Custom Header or Custom Footer -> you can click one of the three parts
Left section, Center section, or Right section
3.You click the Insert Picture button (second button from the right), to insert the image you want to
4.Bam Format Picture - the last button in the Header or Footer button sequence -> Format Picture window opens -> select the Size tab - to change the image size.
2. I want to open EXCEL program is available font of me, for example: VnTime.
1.Bam menu Tools -> Options
2.Of Options window opens -> General tab -> select the font you want in the Standard Font -> click OK -> click OK
3.Thoat from EXCEL and on again
3. When saving the file in EXCEL file that is never in the My Documents folder, I want to automatically save in a different folder, then how?
1.Bam menu Tools -> Options
2.Of Options window opens -> General tab -> you change the
Default file location of the folder you want -> click OK
4. When the formula cell, I want it out of the way without result, and reference to the relevant boxes for reference, then how?
You press CTRL + `(left of the 1 key)
5. In Excel columns should be A, B, C. .. the column is 1,2,3 ... I want to move back into the 1,2,3, A, B, C. .. same
1.Bam menu Tools -> Options
2.Of Options window opens -> General tab -> uncheck the box volume
R1C1 reference style click OK
6. I want to copy from Excel to Word, but still want to retain all of its designs.
1. Highlight the parts that you want to copy in Excel
2. Open to Word -> select the Edit -> Paste Special
3. Select Microsoft Excel Worksheet Object or Formatted Text -> click OK
7. Create vertical text in Excel.
1. Choose the area (Cells) that you want to create vertical text
2. Right click on that area -> select Format Cells -> Alignment tab
3. In the Orientation section -> type 90 in the Degree
4. In the Text Control -> tick option in the Merge cells -> click OK.
8. I want page numbers in Excel, but want it to display the Page 1, Page 2 .... not want to display the Page 1, Page 2 .....
I will guide you to set the page number in the bottom corner for example as follows
1.Bam menu File -> Page Setup select
2.Of Page Setup window opens you select the tab Header / Footer -> click Custom Footer
3.Xuat Footer window appears -> click on the left mouse
Right Selections -> at the cursor position you type page -> next left click left button A button text
4.When the box that appears like Right Selections
Page & [Page] -> click OK -> click OK
9. When I print in Excel itself in accordance with the horizontal line, vertical of the box, what do I do to remove this function?
1 In Excel you select the menu File -> Page Setup select
2.Of Page Setup window opens -> select the Sheet tab -> give the Gridlines check box -> click OK
10. I want to set the default Excel date is used: the number of days 02, 02 and 04 months the number of number of years.
1.You are working to close Excel
2.Bam Start button -> Settings -> choose ControlPanel
3.Cua ControlPanel window opens you double-click the icon left
Regional and Language Opitons
Current appearance RegionalOptions tab -> click the Customize button
4.Cua RegionalOptions Customize window opens -> select the Date tab -> you will see the
Short date format -> you change the contents of which are as follows
dd / mm / yyyy
5.Bam Apply -> click OK
11. I have a row in Excel how do I convert it to a column now?
1.You blackened mark that you want to move goods.
2.Dua cursor position to move.
3.Bam right into that position -> Paste Special.
4.Danh traces on the Transpose -> click OK
12. I use Excel, when I brought up arrow, down or left, or right cursor will not see that anywhere but my screen goes up, down, or left, or right. Treatment I have How reasonable?
Quite simply you alone Scroll Lock key to turn off by pressing the Scroll Lock key once to ScrollLock lights (at the top right corner of the keyboard) is being switched off
13. I have 2 text: * My Documents 1 to page 2 horizontal * Text me to pages and vertical 2 Now I want to put this page to a written text only. How do I do without losing formatting horizontally, vertically it?
First you open the second document, then you follow these steps:
1. You blacked 2 to copy the text to text all 1
2. You return 1 move text cursor to the beginning of the text data page 2
3. Choose Insert -> Break ..
4. In the Break window:
* You choose the Section break types
* Check OK Next page
5. After 2 interrupts the text, your cursor to the top of the text data 2
* Click on File
* Choose Page Setup ... Select the Margins Choose the paper orientation to place horizontally or vertically OK
14. I want to hit the chemical formula H2O for example, I do not like?
1-First you knock H2O as usual.
You blacked 2-2 -> right-click the number 2 just blacked it.
3-Choose FormatCells
4-tick subscript
5-OK job done
15. When I open a new file in Excel that are always accompanied by white Book1 opens, I also changed when opening Excel sheet, but it is still not 16 and still only 3 sheets. Workarounds like?
You must do the following steps:
1-Close Excel back to the desktop screen
2-Click Start -> Search -> For Files or Folders
3-Choose All files and folders
4-Type in the search box as follows: XLStart
5-Click Search
6-Folder Appears XLStart the right hand side of the window
7-Delete all the files in XLStart
8 Restart Excel
16. I use Excel when I made the last hand-fill the correct formula to use of on-line but it shows the results of on-line without giving the formula down -> me how to fix?
You select the Tools Menu
+ Choose Options -> Calculation tab
+ In Calcutation currently marked in the box Manual, you switch to the Automatic marking OK
17. I wish every 3 numbers separated by dots (.) Because it is now a comma (,), how should I do?
First you phsir pile Excel, then do the following steps:
1-Click Start -> select Settings -> choose ControlPanel
2 Double-click the left-and the Regional and Language Options -> Regional Options tab.
3-Press the left mouse button select Customize -> select the Number tab.
4-In Number tab we need to change as follows:
+ Decimal symbol from sign (.) Switched to a comma (,)
+ Digit grouping symbol prison comma (,) move to sign (.)
+ List Separator prison comma (,) move to sign (.)
5.Bam Apply -> click OK
18. In Excel when I type in a cell number 0904294334 and when on the losing end of the line 0. I do not want to do that but still want an enemy to 0 then how?
At the location where you want to hit the box, first type the apostrophe comes with quotes on the keyboard, then you type 0904294334, down the line when you press Enter, the apostrophe will be lost and the number 0904294334 will be preserved without loss of 0 at the beginning.
19. How to increase Sheet in Excel so that when I open Excel Sheet, only 3?
You open Excel, follow these steps:
* Select the Tools
* Choose Options
* In the General tab and select
* You can see the Sheets in new workbook, is now to be 3
* You want to increase how much they choose the arrow pointing up. -> OK
For the last option is enabled you must restart Excel.
20. I want to sort by the Vietnamese in Excel, then how? I typed the name but when that arrangement is faulty. Help me!
In Excel does not support the alphabetical arrangement of the Vietnamese.
You want to arrange to install the support program such as VietKeyOFFICE
When installed VietKeyOFFICE in Excel's menu bar will appear and you will VietKey buttons arranged in such functions
21. I work in the hotel and guests by reason quuan Excel, how do I know which hotel to stay some days to know if the dates go on? Thank you much.
You can do the following:
For example, the box is on the 30/10/2005, the date is 4/7/2005 box
1-In the box you still get results on the cell - cell date
2-You will see a box result value 04/27/1900, but you do not have to worry. Right-click the result cell, choose Format Cells.
3-In that you will see a tab that you are Number and the Number of the line options Category
4-Click OK, you will see the 118 - same as the results that you desire.
22. I have Excel file that accounting forgot PASSWORD, show me how to open that file. I sincerely thank you.
When you forget the password of Word or Excel file, you must install the application program to detect password as PasswareKit, AdvancedOffice PasswordRecovery .... Itself in the Microsoft Office suite does not have such functionality.
23. I open an Excel file that is being opened by any other open several pages in, very uncomfortable, what should I do to remove them?
You must do the following steps:
1-Close Excel back to the desktop screen
2-Click Start -> Search -> For Files or Folders
3-Choose All files and folders
4-Type in the search box as follows: XLStart
5-Click Search
6-Folder Appears XLStart the right hand side of the window
7-Delete all the files in XLStart
8 Restart Excel
24. I took to hiding in my file column A, then column A for how it appears?
When you hide the loss column A, then get back to you to do the following:
1-Put the mouse on column B at the top left to the two-way arrow appears.
2-Hold the left mouse button, drag to the right, the A column will appear.
25. In Excel when I type mathematical formulas, it is not the result of the calculation that it's spending record I've hit the right formula as to why?
1-You select the menu Tools -> Options.
2-Select the View tab, in the Options tab that is part of Windows
Uncheck the 3-Formulas
4-Click OK
25. I am writing a series of Excel and down the line, I want to press any key?
As the editor of a cell (cell) of Excel when you want to stream it at that position you press Alt + Enter
26. How do I set the password for excel file, right?
1-Open the excel file that you want to put a password on the screen.
2-Click File menu, select Save As
3-Click the Tools menu in the Save As, choose General Options
4-box Appear Password to Open and password to Modify must have typed all 04 times.
5-Click OK Save
27. My mouse is broken, I want to switch to the keyboard Sheeet how
You press Ctrl - PageUp to change to the previous page
Ctrl - Page Down to switch to the next page
28. I want to hit the area, the unit what to do? As such m2.
1-m2 First you knock as usual.
You blacked 2-2 -> right-click the number 2 just blacked it.
3-Choose FormatCells
4-tick Supperscript OK
29. In Excel feature is not available for the two rows where the user must use macros, how to proceed as follows
• Open Excel
• Press Alt-F11, appearing MS Visual Basic window
• Click the Insert menu, select Module and you copy the entire contents below
Sub swapRows ()
Xlong As Long Dim
If Selection.Areas.Count <> 2 Then
MsgBox "Must be exactly two swapped the region." & Chr (10) _
& "You have" & Selection.Areas.Count & "zone."
Exit Sub
End If
If Selection.Areas (1). Columns.Count <> Cells.Columns.Count Or _
Selection.Areas (2). Columns.Count <> Then Cells.Columns.Count
MsgBox "Must select entire Rows, columns không đủ"
Exit Sub
End If
AreaSwap1 As Range Dim, areaSwap2 As Range, Range As onepast2
If Selection.Areas (1) (1). Row> Selection.Areas (2) (1). Row Then
Range (Selection.Areas (2). Address & "," & Selection.Areas (1). Address). Select
Selection.Areas (2). Activate
End If
Set areaSwap1 = Selection.Areas (1)
Set areaSwap2 = Selection.Areas (2)
Set onepast2 = areaSwap2.Offset (areaSwap2.Rows.Count, 0). EntireRow
areaSwap2.Cut
areaSwap1.Resize (1). EntireRow.Insert Shift: = xlShiftDown
areaSwap1.Cut
onepast2.Resize (1). EntireRow.Insert Shift: = xlShiftDown
Range (areaSwap1.Address & "," & areaSwap2.Address). Select
xlong = ActiveSheet.UsedRange.Columns.Count 'correct lastcell
End Sub
• Go back to Excel and check the 02 rows of data to be transferred. Attention must check all goods
• Run Macro called swapRows
How May date could be determined in the first weeks?
From date in Excel to determine the weekdays you use WEEKDAY function and days of the week are displayed in the figure. If you want to specify the type from Monday to Sunday, you do the following
Cell A1 is the date. For example, 04/09/2008
Cell B1 will be determined by the following formula
= CHOOSE (WEEKDAY (A1), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")
30. How May date could be determined in the first weeks?
From date in Excel to determine the weekdays you use WEEKDAY function and days of the week are displayed in the figure. If you want to specify the type from Monday to Sunday, you do the following
Cell A1 is the date. For example, 04/09/2008
Cell B1 will be determined by the following formula
= CHOOSE (WEEKDAY (A1), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")
31. Mark formula but still display the results in Excel
Mark formula but still display the results in Excel you do the following:
1. Click the Format menu, choose Cell
2. Select the Protection tab, tick to select the Locked and Hidden, click OK
3. Click the Tools menu, select Protection, click Protect Sheet
You set the password if you do not want people to change
32. Creating a function of the year, day, month between two given time
Creating a function of the year, day, month between the time given to do the following:
1. Open Excel, click Alt-F11
2. Microsoft Visual Basic window opens, select the Insert menu, select Module
3. You cut paste the following content
Function Age (Date1 As Date, Date2 As Date) As String
As Integer Dim Y
As Integer Dim M
As Integer Dim D
Dim Temp1 As Date
Temp1 = DateSerial (Year (Date2), Month (Date1), Day (Date1))
Y = Year (Date2) - Year (Date1) + (Temp1> Date2)
M = Month (Date2) - Month (Date1) - (12 * (Temp1> Date2))
D = Day (Date2) - Day (Date1)
If D <0 Then
M = M - 1
D = Day (DateSerial (Year (Date2), Month (Date2), 0)) + D
End If
Age = Y & "male" & M & "months" & D & "Now"
End Function
4. Quit Microsoft Visual Basic, Excel returns
33.Khi I open an Excel file, then open that file but error messages such as file name already open and can not open the 02 files have the same name as that.
When you open an Excel file, then open that file but error messages such as file name already open and can not open the 02 files have the same name so you should do the following:
1. Close Excel
2. Click Start -> click Run -> type:
"C: \ Program Files \ Microsoft Office \ OfficeXY \ excel.exe" / regserver -> click OK
OfficeXY is depending on where you installed Office on PC
3. Restart your computer
34.Nhung my Excel file when opened read-only to report, I want to restore the old state.
The Excel file in a certain folder marked Read-only again, you do hnu follows:
1. Close Excel
2. Using My Computer or Windows Explorer to find the folder
C: \ Windows \ temp ==> delete the file in which
3. Restart your computer
35. Automatic calibration for both <31/08/2006 4:46:51 AM>
In Excel when we type the contents of the cell or column lot will pass to the default size, to automatically Ching we do the following:
1. Shown below is the box style beyond size
2. You put your mouse on the right border of the left column and double click
36. hello, I asked her for one. I have a an excel file sent to someone else, I want people to stop reading data column milk. eg add new columns or remove columns of data are. How to do it.
In order not to edit any file, you only need to set Password and IT lets see beyond repair, perform the following process:
1. Open the Excel file that you want.
2. Click the menu File -> Save as selected
3. In the Save As window -> select Tools -> choose General Options
4. You set the password for the Password to modify
Click to select traces Read-only recommended -> click OK
5. You type the correct password prior to the Reenter password to modify -> click OK -> click Save
6. Want to repair your Excel file using Excel program Recover
37.Tuc default in Excel when you want the page numbering to start from the first page onwards and now I want to start page numbering from 15 or any other number you want, then how to do?
To estimate the number of pages, for example, from page 15 onwards do the following:
1. Click the menu File -> Page Setup select
2. Select the Page tab -> the firt page number, using the original replacement Auto 15 -> click OK
38.Toi want the text to automatically save in excel how to do it?
To automatically save (AutoSave) in Excel documents, you need to do the following:
1. Open the Excel file that you want.
2. Click the menu File -> Save As select
3. Click Tools -> choose General Options
4. Tick to select the Always create backup -> click OK -> click Save
39. In Excel you do a 5 page long table. I'm supposed to do to the printed paper (which does not appear in the table), the first line in the table on page 1 of 4 pages and is available in the following easy to know the details in the table.
To print a line (or a column) fixed on the following pages, you do the following:
1. Open the Excel file that you intend to print.
2. click menu File -> Page Setup select -> select the Sheet tab
3. You want to print certain fixed lines in all the pages, select Rows to repeat at top
You want to print certain fixed column, you select the Columns to repeat at left
4. You put your mouse on the row or column that would like to print fixed, as shown below
5. Click OK to complete
40. I want to change all uppercase?
To convert all uppercase collage by content below
Sub MakeUpper ()
As String Dim MyText
Dim MyRange As Range
As Integer Dim CellCount
Set MyRange = ActiveSheet.Range (ActiveWindow.Selection.Address)
For CellCount = 1 To MyRange.Cells.Count
If Not MyRange.Cells (CellCount). HasFormula Then
MyText = MyRange.Cells (CellCount). Value
MyRange.Cells (CellCount). Value = UCase (MyText)
End If
Next CellCount
End Sub
Source: Internet
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment