wordpress tips

questions   methods
how to embed content from another site? install iframe plug in, then insert input content like 



 

 tips: quick edit widgets    under ‘customize’ state, hover mouse to the place you want to edit, shift-click
how to add personal customized menu   go to ‘Dashboard’->’Appearance’->’customize’ -> ‘menus’ -> add new menu
 how to add internal link?       highlight words and insert link (Ctrl + K), type in content from your own site and apply              
 how to add read more?    insert read more tag (shift+alt+t) into your article
     
     
     
     
     
     

 

useful wordpress plugins

plugins function 
  • AddToAny Share Buttons
       create share bars contains social medias & create follow me bars
  • Custom Meta Widget
can choose and disable contents in Meta widget
  • DrawIt (draw.io)

Draw and edit flow charts, diagrams, images and more while editing a post.

  • Insert HTML Snippet
Add HTML code to your pages and posts easily using shortcodes
  • Live Composer
Front-end page builder for WordPress with drag and drop editing. Visually customize any page element.
  • Profile Widget Ninja
profile display widget plugin with pic and social media icons
  • Subtitles
add subtitles
  • TinyMCE Color Grid
add more colors while editing
  • TinyMCE Pre Button
add <pre> button
  • WP Downgrade
to either downgrade or update WordPress Core to an arbitrary version of your choice.
  • WP Edit
great content Editing
  • Crayon Syntax Highlighter
highlight codes for various languages
  • WordPress Mobile Pack
convert phone viewers into app viewing 
  • WP Statistics
visiting stat
  • Display Widgets
hide widgets for specific categories, pages, etc

Pandas basis

 

Question  answer explain
 how to get how big in memory a DataFrame object is?  df.info()
 what is the best representative of null value in Pandas object?  np.nan import numpy as np
 what is the best way to slice a DataFrame by index?  df.iloc[-5:, 2:] use iloc method
 how to convert a DataFrame (excluding indexes) to a numpy ndarray?  df.values it is a attribute, can’t be called
 what is the most basic way to create a DataFrame?  pd.DataFrame(dict) pass dictionary to; keys are column names
 what is broadcasting?  pd[‘new’]=7 all the values of the new column will be 7
 how to change df’s column names, index names?  pd.columns = [‘a’,’b’,…]

pd.index = [‘c’,’d’,…]

assign value directly
 when read csv, how to specify names of the column  pd.read_csv(path, names=[‘a’,’b’,…..])  instead, pass header=None will prevent pandas using data as column names, but use 0,1,2,3 ….
when read csv, how to let pandas to turn some specific values into NaN? pd.read_csv(path, na_values = ‘-1’)

pdf.read_csv(path, na_values = {‘column3’:[‘ -2’, ‘wtf’,…]})

all the values which is character ‘-1’ will be rendered to NaN
how to parse data in reading csv pd.read_csv(path, parse_dates = [[0,1,2]]) pandas will parse column 1, 2, 3 into one datetype column
does index of df have a name? pd.index.name = ‘xxx’ assign a name to the index of df
how to save df to a csv file with other delimiters  rather than ‘,’ pd.to_csv(path, sep=’\t’) save to a csv file which separates data by tab

how to batch convert string to Date type

df[‘datestring’]=pd.to_datetime(df[‘datestring’])

how to get 2 DataFrame together,  & append one df to another?

git command

Git task Notes Git commands
Tell Git who you are Configure the author name and email address to be used with your commits.

Note that Git strips some characters (for example trailing periods) from user.name.

git config --global user.name "Sam Smith"

git config --global user.email sam@example.com

Create a new local repository git init
Check out a repository Create a working copy of a local repository: git clone /path/to/repository
For a remote server, use: git clone username@host:/path/to/repository
Add files Add one or more files to staging (index): git add filename
Commit Commit changes to head (but not yet to the remote repository): git commit -m "Commit message"
Commit any files you’ve added with git add, and also commit any files you’ve changed since then: git commit -a
Push Send changes to the master branch of your remote repository: git push origin master
Status List the files you’ve changed and those you still need to add or commit: git status
Connect to a remote repository If you haven’t connected your local repository to a remote server, add the server to be able to push to it: git remote add origin <server>
List all currently configured remote repositories: git remote -v
Branches Create a new branch and switch to it: git checkout -b <branchname>
Switch from one branch to another: git checkout <branchname>
List all the branches in your repo, and also tell you what branch you’re currently in: git branch
Delete the feature branch: git branch -d <branchname>
Push the branch to your remote repository, so others can use it: git push origin <branchname>
Push all branches to your remote repository: git push --all origin
Delete a branch on your remote repository: git push origin :<branchname>
Update from the remote repository

 

Fetch and merge changes on the remote server to your working directory: git pull
To merge a different branch into your active branch: git merge <branchname>
View all the merge conflicts:

View the conflicts against the base file:

Preview changes, before merging:

git diff

git diff --base <filename>

git diff <sourcebranch> <targetbranch>

After you have manually resolved any conflicts, you mark the changed file: git add <filename>
Tags You can use tagging to mark a significant changeset, such as a release: git tag 1.0.0 <commitID>
CommitId is the leading characters of the changeset ID, up to 10, but must be unique. Get the ID using: git log
Push all tags to remote repository: git push --tags origin
Undo local changes If you mess up, you can replace the changes in your working tree with the last content in head:

Changes already added to the index, as well as new files, will be kept.

git checkout -- <filename>
Instead, to drop all your local changes and commits, fetch the latest history from the server and point your local master branch at it, do this: git fetch origin

git reset --hard origin/master

Search Search the working directory for foo(): git grep "foo()"

excel shortcuts 1

excel basics

 descriptionshortcutscomments
1upper  right cornerribbon display options
2upper left cornerquick access bar can choose show below the ribbon
3undo/ redoCtrl + Z/ Ctrl + Y in other platform --redo : Ctrl+ Shift + Z
4fix column width for double clickHome -> Wrap Text
5switch sheetsCtrl + Page up/down
6bold/italic/underlineCtrl + B/I/U
7find/replaceCtrl + F/H
8texts are left aligned / numbers are right aligned
9insert comment to a cellShift + F2
10show all commentsReview -> show all comments
11save as F12
12count non-empty cells =COUNTA(selected cells)
13count numbers alone =COUNT(selected cells)
14find second largest NO. =large(cells, 2)
15all column/ rows to same widthselect all target columns/ rows -> drag any edges
16"Enter" within a cell
new paragraph
Alt + Enter
17format cellCtrl + 1
Ctrl + Shift + F
18convert to tableCtrl + T
19slicer have table already
insert slicer
20keep ratio of inserted shapeshold Shift
21print with titles (columns /rows)page layout -> print titles
22page break previewbottom right corner
23print area selectionpage layout -> print area
24create a chart in a new sheetselect data then press F11
25create chart in the same sheetselect data then Alt + F1design tab
26sparklinesquick analysis -> sparklines
insert -> sparklines
27divide sheet by rowsgo to column one -> splitdouble click to cancel
28divide sheet by columnsgo to row one -> split
29only see summary of large datadata -> group-> auto outline
30hide/create outline symbolCtrl + 8
31create a new sheet on the leftShift + F11
32if func return string values must be quoted by double quote "string"
33vlookup for approx match,
input table
value must be ascending order
34 =function, auto completeTab
35vlookup default value is 1 approx matchthe fourth para set to 0 to exact match
36 =countif() =countif() =sumif() =averageif()
37format cell -> protectionReview -> show all comments
38when save add passwdsave as -> tools -> general options
39track changesReview -> track changes
40sortdata -> sort
41subtotal data -> subtotal
42Only select visible data
(before copy, or etc)
Alt + ;
43Refresh (for pivot table)Alt + F5
44pivot table see detailsdouble click
45pivot chartsinsert -> pivot chart
pivot table Alt+F1
46what if analysisdata -> what if analysis ->
goal seek
47solverdata -> solver
options -> add-ins
48scenario what-if analysis -> scenario manager
49sensitivity analysiswhat-if analysis -> data table
50strike throughCtrl + 5
51select(highlight) cells with formulashome -> find and select -> formulas
52Macrosview -> Macros -> record
and set shortcut
53select(highlight) cells only contains numbers/ text/ othershome -> find and select -> go to special
54stop recording Macrobottom left corner stop
55assign Macro to a button(shape, icons, pictures, etc)right click shape -> assign macro
56repeat last one actionAlt + Enter
57redoCtrl + Y
or F4
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100

multiple worksheets/workbooks managing

description  shortcuts
insert hyperlink to a cellCtrl + K
mouse to lower left cornerCtrl+left clickScroll to the first/ last sheet
show how many sheets the workbook havemouse to lower left corner, right click
go to the first row of one columndouble click the top edge of any cell of that columnCtrl + up arrow
switch worksheetsCtrl + page up/ page down
go the first cell of the sheetupper left cornerCtrl + Home
jump to the last cell of this work sheetCtrl + End
go to the end of one columnleft /right is the samedouble click the bottom edge of any cell of that columnCtrl + down arrow
move one screen to the right/ leftfor ultra wide sheetsAlt + page down/
Alt + page up
if hold arrow will go to the very end
insert rowsgo the left most row number --> right click --> insert
merge cellsHome -> merge
wrap cellsHome -> Wrap text
add new sheets to the left of the current sheetselect current sheet and press
Shift + F11
add new sheets to the right of the current sheetselect current sheet -> right click the '+' icon on the right
group select multiple sheetscan then right click to insert contentson the bottom -> Shift + left click sheets
Ctrl + any single sheet
create a copy sheetselect sheet Ctrl + Drag to target position ;
right click sheet -> move or copy
color sheetright click sheet -> Tab color
unhide hidden rows / columnsright click rows / columns -> unhide

or double click row/column's edge
select all -> upper left triangle ->

or select certain rows / columns
sheets can be hide/ unhideright click sheet/sheets
lock workbook manipulationReview -> Protect Workbook
if open multiple workbooks (windows), arrange positions(view -> New window)
view -> Arrange all (current window will be the main)
hide ribbon double click current ribbon
switch windowview -> switch window
open the same workbook in a new windowchange any of the two will change allview -> new window
mouse drag/ copymove: select -> drag
copy: select-> Ctrl+drag
move/ drag to another worksheet or self worksheet in new windfast drag selected data to another window
mouse
Insert row/ column
mouse +
Shift
make change to multiple sheetsselect (group) multiple sheets, then make changes
best fit space of multiple columns /rowsselect columns/ rows first, then double chick any edges
(if grouped will change all)
copy interactive data/ formula/ results to another sheet/placecopy then go to destination, right click ->paste special -?> paste link
then drag e.g. right, that cell will be mapped to the original worksheetcan combine with double click + F4
absolute address
reference to another sheet!ERROR! illegal character '!'
show formula (content after '=')put a space before =
create formula
string concat
!ERROR! illegal character '&'cellref reference the cell with value of the name of destination worksheetuse & to paste cellref to string

string must be quoted with double quote "string"
display formula in another cell single cell, select, F2Ctrl + `
or formuls -> show formulas
!ERROR! undefined variable 'formulatext'
manipulate multiple sheets. sum(one cell from a sheet for 100 sheets)"3D" formulaformula ->autosum
within =sum()
sheet selection, first sheet, then Ctrl chick right arrow will go to the last sheet, Shift click
do not want to move the active cell but comfirmCtrl + Enter
Consolidate Data -> Consolidate
grand total select cells with blank edges
Alt + =
or formulas -> autosum
input value to multiple cells at once select multiple cells, input value-> Ctrl + Enter
pivot table wizard or quick access toolbar
customize toolbar
more comments
Alt+ D then P
multiple consolidation ranges
with pivot tabledesign tab
navigate multiple workbooksview -> switch windows
add anything to quick access toolbarright click target button, add to quick access toolbar
navigate tabs to the rightCtrl+F6Ctrl+Tab
navigate tabs to the leftCtrl+Shift+F6Ctrl+Shift+Tab
open a new workbookCtrl+N
close all open fileshold Shift and mouse right click upper right 'X'
fill multiple selected cells with formulafrom formula cell, Shift arrow select cell, then Ctrl+ D/ Ctrl + Rfrom formula cell, Shift arrow select cells, press F2 go back to formula cell, then Ctrl+ Enter
paste specialCtrl + Alt + E
or Alt + E + S
format cellsCtrl + Shift + F
exam data link from other workbookdata -> edit links
select all sheets and findbottom left corner, right click any sheet -> select all sheets, then upper left corner right click select all cells, then Ctrl + F (Home -> Find & select)
if linkage to another workbook, formula contains '['
pivot table insert pivot table
clear content delete

 

Plot with Seaborn

Statistical Plotting with Seaborn

In [1]:
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
%matplotlib inline

load a dataset online from seaborn

In [2]:
tip=sns.load_dataset('tips')
In [3]:
tip.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 244 entries, 0 to 243
Data columns (total 7 columns):
total_bill    244 non-null float64
tip           244 non-null float64
sex           244 non-null category
smoker        244 non-null category
day           244 non-null category
time          244 non-null category
size          244 non-null int64
dtypes: category(4), float64(2), int64(1)
memory usage: 6.8 KB
In [4]:
tip.head(3)
Out[4]:
total_bill tip sex smoker day time size
0 16.99 1.01 Female No Sun Dinner 2
1 10.34 1.66 Male No Sun Dinner 3
2 21.01 3.50 Male No Sun Dinner 3

visualizing regressions

  • Plot data and regression model fits across a FacetGrid.
In [5]:
sns.lmplot('total_bill','tip',tip,size=3,aspect=2)
Out[5]:
<seaborn.axisgrid.FacetGrid at 0x7f71804eb950>

group by categorical column

In [6]:
sns.lmplot(x='total_bill',y='tip',data=tip, size=3,
          col='sex')
Out[6]:
<seaborn.axisgrid.FacetGrid at 0x7f717db077d0>

plot group data in the same graph

In [7]:
sns.lmplot(x='total_bill',y='tip',data=tip, size=3, aspect=2,
          hue='sex', palette='Set1')
Out[7]:
<seaborn.axisgrid.FacetGrid at 0x7f71804eba90>

plot Residuals

  • residplot()
In [8]:
tip.head(1)
Out[8]:
total_bill tip sex smoker day time size
0 16.99 1.01 Female No Sun Dinner 2
In [9]:
sns.residplot(x='total_bill',y='tip',data=tip,color='indianred')
Out[9]:
<matplotlib.axes._subplots.AxesSubplot at 0x7f717cf9e7d0>

Higher-order regressions

  • When there are more complex relationships between two variables, a simple first order regression is often not sufficient to accurately capture the relationship between the variables. Seaborn makes it simple to compute and visualize regressions of varying orders.

  • sns.regplot()

  • the function sns.lmplot() is a higher-level interface to sns.regplot().

    • A principal difference between sns.lmplot() and sns.regplot() is the way in which matplotlib options are passed (sns.regplot() is more permissive).

    • For both sns.lmplot() and sns.regplot(), the keyword order is used to control the order of polynomial regression.

    • The function sns.regplot() uses the argument scatter=None to prevent plotting the scatter plot points again.

In [10]:
tip.head(1)
Out[10]:
total_bill tip sex smoker day time size
0 16.99 1.01 Female No Sun Dinner 2
In [11]:
# Generate a scatter plot of 'weight' and 'mpg' using red circles
plt.scatter(tip['total_bill'], tip['tip'], label='data', color='red', marker='o', alpha=.5)

# Plot in blue a linear regression of order 1 between 'weight' and 'mpg'
sns.regplot(x='total_bill', y='tip', data=tip, scatter=None, color='blue', label='order 1')

# Plot in green a linear regression of order 2 between 'weight' and 'mpg'
sns.regplot(x='total_bill', y='tip', data=tip, scatter=None, order=2, color='green', label='order 2')

sns.regplot(x='total_bill', y='tip', data=tip, scatter=None, order=3, color='purple', label='order 2')


# Add a legend and display the plot
plt.legend(loc='upper right')
plt.show()

Visualizing univariate distributions

Strip plot

swarmplot

In [12]:
sns.stripplot(y= 'tip', data=tip)
plt.ylabel('tip ($)')
Out[12]:
<matplotlib.text.Text at 0x7f717ce6aa50>
In [13]:
sns.stripplot(x='day', y='tip', data=tip)
plt.ylabel('tip ($)')
Out[13]:
<matplotlib.text.Text at 0x7f717ce22710>
In [14]:
sns.stripplot(x='day', y='tip', data=tip, size=4, jitter=True)
plt.ylabel('tip ($)')
Out[14]:
<matplotlib.text.Text at 0x7f717cc93750>
In [15]:
sns.swarmplot(x='day', y='tip', data=tip)
plt.ylabel('tip ($)')
Out[15]:
<matplotlib.text.Text at 0x7f717cca2ad0>
In [16]:
sns.swarmplot(x='day', y='tip', data=tip, hue='sex',  palette='Set1')
plt.ylabel('tip ($)')
Out[16]:
<matplotlib.text.Text at 0x7f717cb27350>
In [17]:
sns.swarmplot(x='tip', y='day', data=tip, hue='sex',  orient='h')
plt.ylabel('tip ($)')
Out[17]:
<matplotlib.text.Text at 0x7f717ca7a690>

Violin plot

In [18]:
plt.subplot(1,2,1)
sns.boxplot(x='day', y='tip', data=tip)
plt.ylabel('tip ($)')

plt.subplot(1,2,2)
sns.violinplot(x='day', y='tip', data=tip)
plt.ylabel('tip ($)')
plt.tight_layout()
In [19]:
sns.violinplot(x='day', y='tip', data=tip, inner=None,
color='lightgray')

sns.stripplot(x='day', y='tip', data=tip, size=4,
jitter=True)

plt.ylabel('tip ($)')
Out[19]:
<matplotlib.text.Text at 0x7f717ca25dd0>

Visualizing multivariate distributions

Joint plots

In [20]:
sns.jointplot(x= 'total_bill', y= 'tip', data=tip, size=5)
Out[20]:
<seaborn.axisgrid.JointGrid at 0x7f717ca34a10>

Using kde=True

  • kernal density distribution
In [21]:
sns.jointplot(x='total_bill', y= 'tip', data=tip,
              kind='kde', size=5)
Out[21]:
<seaborn.axisgrid.JointGrid at 0x7f717ce8b050>

Pair plot

In [22]:
sns.pairplot(tip, size=2)
Out[22]:
<seaborn.axisgrid.PairGrid at 0x7f717c398c50>
In [23]:
sns.pairplot(tip, hue='sex', kind='reg')
Out[23]:
<seaborn.axisgrid.PairGrid at 0x7f717b9e4b10>

heatmap

  • covariance matrix
In [24]:
tip.cov()
Out[24]:
total_bill tip size
total_bill 79.252939 8.323502 5.065983
tip 8.323502 1.914455 0.643906
size 5.065983 0.643906 0.904591
In [25]:
tip.corr()
Out[25]:
total_bill tip size
total_bill 1.000000 0.675734 0.598315
tip 0.675734 1.000000 0.489299
size 0.598315 0.489299 1.000000
In [26]:
sns.heatmap(tip.corr())
Out[26]:
<matplotlib.axes._subplots.AxesSubplot at 0x7f717b287d10>
In [ ]:
 

Python odds and ends

 from sys import argv unpack argv

a,b,c…=argv

> python file.py ‘b’,’c’,…

argv will be a list contains

[‘file.py’, ‘a’,’b’,…]

a = python file name itself

b,c, …. is the variables pass when exec the python file

 The argument mode points to a string beginning with one of the following
 sequences (Additional characters may follow these sequences.):

 ``r''   Open text file for reading.  The stream is positioned at the
         beginning of the file.

 ``r+''  Open for reading and writing.  The stream is positioned at the
         beginning of the file.

 ``w''   Truncate file to zero length or create text file for writing.
         The stream is positioned at the beginning of the file.

 ``w+''  Open for reading and writing.  The file is created if it does not
         exist, otherwise it is truncated.  The stream is positioned at
         the beginning of the file.

 ``a''   Open for writing.  The file is created if it does not exist.  The
         stream is positioned at the end of the file.  Subsequent writes
         to the file will always end up at the then current end of file,
         irrespective of any intervening fseek(3) or similar.

 ``a+''  Open for reading and writing.  The file is created if it does not
         exist.  The stream is positioned at the end of the file.  Subse-
         quent writes to the file will always end up at the then current
         end of file, irrespective of any intervening fseek(3) or similar.
                  | r   r+   w   w+   a   a+
------------------|--------------------------
read              | +   +        +        +
write             |     +    +   +    +   +
create            |          +   +    +   +
truncate          |          +   +
position at start | +   +    +   +
position at end   |                   +   +

where meanings are: (just to avoid any misinterpretation)

  • read – reading from file is allowed
  • write – writing to file is allowed
  • create – file is created if it does not exist yet
  • trunctate – during opening of the file it is made empty (all content of the file is erased)
  • position at start – after file is opened, initial position is set to the start of the file
  • position at end – after file is opened, initial position is set to the end of the file
  • close — Closes the file. Like File->Save.. in your editor.
  • read — Reads the contents of the file. You can assign the result to a variable.
  • readline — Reads just one line of a text file.
  • truncate — Empties the file. Watch out if you care about the file.
  • write('stuff') — Writes “stuff” to the file.
 file manipulate manipulate.py:

from sys import argv

script, input_file = argv

current_file = open(input_file)

def print_all(f):
print f.read()

def rewind(f):
f.seek(0)

def print_a_line(line_count, f):
print line_count, f.readline()

 $ python manipulate.py test.txt

Why does seek(0) not set the current_line to 0?
First, the seek() function is dealing in bytes, not lines. The code seek(0) moves the file to the 0 byte (first byte) in the file. Second, current_line is just a variable and has no real connection to the file at all. We are manually incrementing it.

 

How does readline() know where each line is?
Inside readline() is code that scans each byte of the file until it finds a \n character, then stops reading the file to return what it found so far. The file f is responsible for maintaining the current position in the file after each readline() call, so that it will keep reading each line.

Excel shortcuts (Chinese) tips

 problemshortcut
0快捷键之在工作表中移动和滚动向上、下、左或右移动单元格箭头键
1移动到当前数据区域的边缘CTRL+ 箭头键
2移动到行首HOME
3移动到工作表的开头CTRL+HOME
4移动到工作表的最后一个单元格。CTRL+END
5向下移动一屏PAGE DOWN
6向上移动一屏PAGE UP
7向右移动一屏ALT+PAGE DOWN
8向左移动一屏ALT+PAGE UP
9移动到工作簿中下一个工作表CTRL+PAGE DOWN
10移动到工作簿中前一个工作表CTRL+PAGE UP
11移动到下一工作簿或窗口CTRL+F6 或 CTRL+TAB
12移动到前一工作簿或窗口CTRL+SHIFT+F6
13移动到已拆分工作簿中的下一个窗格F6
14移动到被拆分的工作簿中的上一个窗格SHIFT+F6
15滚动并显示活动单元格CTRL+BACKSPACE
16显示“定位”对话框F5
17显示“查找”对话框SHIFT+F5
18重复上一次“查找”操作SHIFT+F4
19在保护工作表中的非锁定单元格之间移动TAB
202>Excel快捷键之处于END模式时在工作表中移动
21打开或关闭 END 模式END
22在一行或列内以数据块为单位移动END, 箭头键
23移动到工作表的最后一个单元格.END, HOME
24在当前行中向右移动到最后一个非空白单元格。END, ENTER
253>Excel快捷键之处于“滚动锁定”模式时在工作表中移动
26打开或关闭滚动锁定SCROLL LOCK
27移动到窗口中左上角处的单元格HOME
28移动到窗口中右下角处的单元格END
29向上或向下滚动一行上箭头键或下箭头键
30向左或向右滚动一列左箭头键或右箭头键
314>Excel快捷键之用于预览和打印文档
32显示“打印”对话框CTRL+P
33在打印预览中时
34当放大显示时,在文档中移动箭头键
35当缩小显示时,在文档中每次滚动一页PAGE UP
36当缩小显示时,滚动到第一页CTRL+上箭头键
37当缩小显示时,滚动到最后一页CTRL+下箭头键
385>Excel快捷键之用于工作表、图表和宏
39插入新工作表SHIFT+F11
40创建使用当前区域的图表F11 或 ALT+F1
41显示“宏”对话框ALT+F8
42显示“Visual Basic 编辑器”ALT+F11
43插入 Microsoft Excel 4.0 宏工作表CTRL+F11
44移动到工作簿中的下一个工作表CTRL+PAGE DOWN
45移动到工作簿中的上一个工作表CTRL+PAGE UP
46选择工作簿中当前和下一个工作表SHIFT+CTRL+PAGE DOWN
47选择当前工作簿或上一个工作簿SHIFT+CTRL+PAGE UP
486>Excel快捷键之选择图表工作表
49选择工作簿中的下一张工作表CTRL+PAGE DOWN
50选择工作簿中的上一个工作表CTRL+PAGE UP,END, SHIFT+ENTER
517>Excel快捷键之用于在工作表中输入数据
52完成单元格输入并在选定区域中下移ENTER
53在单元格中折行ALT+ENTER
54用当前输入项填充选定的单元格区域CTRL+ENTER
55完成单元格输入并在选定区域中上移SHIFT+ENTER
56完成单元格输入并在选定区域中右移TAB
57完成单元格输入并在选定区域中左移SHIFT+TAB
58取消单元格输入ESC
59删除插入点左边的字符,或删除选定区域BACKSPACE
60删除插入点右边的字符,或删除选定区域DELETE
61删除插入点到行末的文本CTRL+DELETE
62向上下左右移动一个字符箭头键
63移到行首HOME
64重复最后一次操作F4 或 CTRL+Y
65编辑单元格批注SHIFT+F2
66由行或列标志创建名称CTRL+SHIFT+F3
67向下填充CTRL+D
68向右填充CTRL+R
69定义名称CTRL+F3
708>Excel快捷键之设置数据格式
71显示“样式”对话框ALT+' (撇号)
72显示“单元格格式”对话框CTRL+1
73应用“常规”数字格式CTRL+SHIFT+~
74应用带两个小数位的“贷币”格式CTRL+SHIFT+$
75应用不带小数位的“百分比”格式CTRL+SHIFT+%
76应用带两个小数位的“科学记数”数字格式CTRL+SHIFT+^
77应用年月日“日期”格式CTRL+SHIFT+#
78应用小时和分钟“时间”格式,并标明上午或下午CTRL+SHIFT+@
79应用具有千位分隔符且负数用负号 (-) 表示CTRL+SHIFT+!
80应用外边框CTRL+SHIFT+&
81删除外边框CTRL+SHIFT+_
82应用或取消字体加粗格式CTRL+B
83应用或取消字体倾斜格式CTRL+I
84应用或取消下划线格式CTRL+U
85应用或取消删除线格式CTRL+5
86隐藏行CTRL+9
87取消隐藏行CTRL+SHIFT+( 左括号
88隐藏列CTRL+0(零)
89取消隐藏列CTRL+SHIFT+)右括号
909>Excel快捷键之编辑数据
91编辑活动单元格并将插入点放置到线条末尾F2
92取消单元格或编辑栏中的输入项ESC
93编辑活动单元格并清除其中原有的内容BACKSPACE
94将定义的名称粘贴到公式中F3
95完成单元格输入ENTER
96将公式作为数组公式输入CTRL+SHIFT+ENTER
97在公式中键入函数名之后,显示公式选项板CTRL+A
98在公式中键入函数名后为该函数插入变量名和括号CTRL+SHIFT+A
99显示“拼写检查”对话框。F7 键
10010>Excel快捷键之插入、删除和复制选中区域
101复制选定区域CTRL+C
102剪切选定区域CTRL+X
103粘贴选定区域CTRL+V
104清除选定区域的内容DELETE
105删除选定区域CTRL+ 连字符
106撤消最后一次操作CTRL+Z
107插入空白单元格CTRL+SHIFT+ 加号
10811>Excel快捷键之在选中区域内移动
109在选定区域内由上往下移动ENTER
110在选定区域内由下往上移动SHIFT+ENTER
111在选定区域内由左往右移动TAB
112在选定区域内由右往左移动SHIFT+TAB
113按顺时针方向移动到选定区域的下一个角CTRL+PERIOD
114右移到非相邻的选定区域CTRL+ALT+右箭头键
115左移到非相邻的选定区域CTRL+ALT+左箭头键
11612>Excel快捷键之选择单元格、列或行
117选定当前单元格周围的区域CTRL+SHIFT+*(星号)
118将选定区域扩展一个单元格宽度SHIFT+ 箭头键
119选定区域扩展到单元格同行同列的最后非空单元格CTRL+SHIFT+ 箭头键
120将选定区域扩展到行首SHIFT+HOME
121将选定区域扩展到工作表的开始CTRL+SHIFT+HOME
122将选定区域扩展到工作表的最后一个使用的单元格CTRL+SHIFT+END
123选定整列CTRL+SPACEBAR
124选定整行SHIFT+SPACEBAR
125选定整个工作表CTRL+A
126如果选定了多个单元格则只选定其中的单元格SHIFT+BACKSPACE
127将选定区域向下扩展一屏SHIFT+PAGE DOWN
128将选定区域向上扩展一屏SHIFT+PAGE UP
129选定了一个对象,选定工作表上的所有对象CTRL+SHIFT+SPACEBAR
130在隐藏对象、显示对象与对象占位符之间切换CTRL+6
131显示或隐藏“常用”工具栏CTRL+7
132使用箭头键启动扩展选中区域的功能F8
133将其他区域中的单元格添加到选中区域中SHIFT+F8
134将选定区域扩展到窗口左上角的单元格SCROLLLOCK, SHIFT+HOME
135将选定区域扩展到窗口右下角的单元格SCROLLLOCK, SHIFT+END
13613>Excel快捷键之处于End模式时展开选中区域
137打开或关闭 END 模式END
138将选定区域扩展到单元格同列同行的最后非空单元格END, SHIFT+ 箭头键
139将选定区域扩展到工作表上包含数据的最后一个单元格END, SHIFT+HOME
140将选定区域扩展到当前行中的最后一个单元格END, SHIFT+ENTER
14114>Excel快捷键之选择含有特殊字符单元格
142选中活动单元格周围的当前区域CTRL+SHIFT+*(星号)
143选中当前数组,此数组是活动单元格所属的数组CTRL+/
144选定所有带批注的单元格CTRL+SHIFT+O (字母 O)
145选择行中不与该行内活动单元格的值相匹配的单元格CTRL+\
146选中列中不与该列内活动单元格的值相匹配的单元格CTRL+SHIFT+|
147选定当前选定区域中公式的直接引用单元格CTRL+[ (左方括号)
148选定当前选定区域中公式直接或间接引用的所有单元格CTRL+SHIFT+{ 左大括号
149只选定直接引用当前单元格的公式所在的单元格CTRL+] (右方括号)
150选定所有带有公式的单元格,这些公式直接或间接引用当前单元格CTRL+SHIFT+}右大括号