Excel技巧接龍

tmtony

相信大家都玩過(guò)成語(yǔ)接龍，我們也來(lái)個(gè)Excel的技巧接龍游戲，看看此龍能接多長(zhǎng)。

接龍規(guī)則:

  - 只要是你認(rèn)為是好的使用或開(kāi)發(fā)技巧和文章,就可跟貼

  - 別人推薦給你的Excel使用和開(kāi)發(fā)技巧，也可跟貼

  - 國(guó)外或國(guó)內(nèi)Excel網(wǎng)站的技巧，翻譯或整理的文章，也可跟貼

  - 技巧難度可以從簡(jiǎn)單、中級(jí)到高級(jí)應(yīng)用。

  - 技巧內(nèi)容可以任意。比如工作表、單元格、宏、函數(shù)、模板等使用技巧、vba、ActiveX、加載項(xiàng)等。

  - 跟貼前請(qǐng)盡量看完樓上的貼，以避免重復(fù)。

  - 為了尊重源作者，請(qǐng)盡量寫(xiě)明源作者

  - 非常好的技巧貼，可被挑選放入網(wǎng)站首頁(yè)的文章區(qū)以及被挑選到21cn的IT頻道

  - 跟貼次數(shù)不限，但盡量避免閑聊，多發(fā)技巧文章貼

此貼總置頂，讓Excel的網(wǎng)友都來(lái)發(fā)揮自己的一份熱量，來(lái)了Office中國(guó)永不沉落的貼子。

Word、sharepint等隨后也將增加相應(yīng)的接龍貼。

老鬼

先來(lái)一個(gè)簡(jiǎn)單的：在單元格中輸入“=TEXT(NOW(),"aaaa")”，將得知當(dāng)天是星期幾。不好意思，這個(gè)方法是我無(wú)意中發(fā)現(xiàn)的~~~~~~~~

碧海藍(lán)天

好像沒(méi)有看到用照相機(jī)這個(gè)工具的，工具，自定義， 命令選項(xiàng)卡中， 工具類(lèi)別， 右邊選項(xiàng)中，拖動(dòng)照相機(jī)到工具欄上，回到工作表，選中要?jiǎng)討B(tài)引用的單元格數(shù)據(jù)，按下照相機(jī)，再放到指定位置，可以實(shí)現(xiàn)動(dòng)態(tài)引用

NeilChen

說(shuō)一個(gè)很少有人知道的:Ctrl+~顯示當(dāng)然工作表中所有用到的公式

ui

也摘抄一個(gè)，公歷與農(nóng)歷的轉(zhuǎn)換：

Option Explicit

Dim WeekName(7), MonthAdd(11), NongliData(99), TianGan(9), DiZhi(11), ShuXia

ng(11), DayName(30), MonName(12)

Dim curTime, curYear, curMonth, curDay, curWeekday

Dim GongliStr, WeekdayStr, NongliStr, NongliDayStr

Dim i, m, n, k, isEnd, bit, TheDate

Private Sub Form_Load()

'獲取當(dāng)前系統(tǒng)時(shí)間

curTime = Now()

'星期名

WeekName(0) = " * "

WeekName(1) = "星期日"

WeekName(2) = "星期一"

WeekName(3) = "星期二"

WeekName(4) = "星期三"

WeekName(5) = "星期四"

WeekName(6) = "星期五"

WeekName(7) = "星期六"

'天干名稱(chēng)

TianGan(0) = "甲"

TianGan(1) = "乙"

TianGan(2) = "丙"

TianGan(3) = "丁"

TianGan(4) = "戊"

TianGan(5) = "己"

TianGan(6) = "庚"

TianGan(7) = "辛"

TianGan(8) = "壬"

TianGan(9) = "癸"

'地支名稱(chēng)

DiZhi(0) = "子"

DiZhi(1) = "丑"

DiZhi(2) = "寅"

DiZhi(3) = "卯"

DiZhi(4) = "辰"

DiZhi(5) = "巳"

DiZhi(6) = "午"

DiZhi(7) = "未"

DiZhi(8) = "申"

DiZhi(9) = "酉"

DiZhi(10) = "戌"

DiZhi(11) = "亥"

'屬相名稱(chēng)

ShuXiang(0) = "鼠"

ShuXiang(1) = "牛"

ShuXiang(2) = "虎"

ShuXiang(3) = "兔"

ShuXiang(4) = "龍"

ShuXiang(5) = "蛇"

ShuXiang(6) = "馬"

ShuXiang(7) = "羊"

ShuXiang(8) = "猴"

ShuXiang(9) = "雞"

ShuXiang(10) = "狗"

ShuXiang(11) = "豬"

'農(nóng)歷日期名

DayName(0) = "*"

DayName(1) = "初一"

DayName(2) = "初二"

DayName(3) = "初三"

DayName(4) = "初四"

DayName(5) = "初五"

DayName(6) = "初六"

DayName(7) = "初七"

DayName(8) = "初八"

DayName(9) = "初九"

DayName(10) = "初十"

DayName(11) = "十一"

DayName(12) = "十二"

DayName(13) = "十三"

DayName(14) = "十四"

DayName(15) = "十五"

DayName(16) = "十六"

DayName(17) = "十七"

DayName(18) = "十八"

DayName(19) = "十九"

DayName(20) = "二十"

DayName(21) = "廿一"

DayName(22) = "廿二"

DayName(23) = "廿三"

DayName(24) = "廿四"

DayName(25) = "廿五"

DayName(26) = "廿六"

DayName(27) = "廿七"

DayName(28) = "廿八"

DayName(29) = "廿九"

DayName(30) = "三十"

'農(nóng)歷月份名

MonName(0) = "*"

MonName(1) = "正"

MonName(2) = "二"

MonName(3) = "三"

MonName(4) = "四"

MonName(5) = "五"

MonName(6) = "六"

MonName(7) = "七"

MonName(8) = "八"

MonName(9) = "九"

MonName(10) = "十"

MonName(11) = "十一"

MonName(12) = "臘"

'公歷每月前面的天數(shù)

MonthAdd(0) = 0

MonthAdd(1) = 31

MonthAdd(2) = 59

MonthAdd(3) = 90

MonthAdd(4) = 120

MonthAdd(5) = 151

MonthAdd(6) = 181

MonthAdd(7) = 212

MonthAdd(8) = 243

MonthAdd(9) = 273

MonthAdd(10) = 304

MonthAdd(11) = 334

'農(nóng)歷數(shù)據(jù)

NongliData(0) = 2635

NongliData(1) = 333387

NongliData(2) = 1701

NongliData(3) = 1748

NongliData(4) = 267701

NongliData(5) = 694

NongliData(6) = 2391

NongliData(7) = 133423

NongliData(8) = 1175

NongliData(9) = 396438

NongliData(10) = 3402

NongliData(11) = 3749

NongliData(12) = 331177

NongliData(13) = 1453

NongliData(14) = 694

NongliData(15) = 201326

NongliData(16) = 2350

NongliData(17) = 465197

NongliData(18) = 3221

NongliData(19) = 3402

NongliData(20) = 400202

NongliData(21) = 2901

NongliData(22) = 1386

NongliData(23) = 267611

NongliData(24) = 605

NongliData(25) = 2349

NongliData(26) = 137515

NongliData(27) = 2709

NongliData(28) = 464533

NongliData(29) = 1738

NongliData(30) = 2901

NongliData(31) = 330421

NongliData(32) = 1242

NongliData(33) = 2651

NongliData(34) = 199255

NongliData(35) = 1323

NongliData(36) = 529706

NongliData(37) = 3733

NongliData(38) = 1706

NongliData(39) = 398762

NongliData(40) = 2741

NongliData(41) = 1206

NongliData(42) = 267438

NongliData(43) = 2647

NongliData(44) = 1318

NongliData(45) = 204070

NongliData(46) = 3477

NongliData(47) = 461653

NongliData(48) = 1386

NongliData(49) = 2413

NongliData(50) = 330077

NongliData(51) = 1197

NongliData(52) = 2637

NongliData(53) = 268877

NongliData(54) = 3365

NongliData(55) = 531109

NongliData(56) = 2900

NongliData(57) = 2922

NongliData(58) = 398042

NongliData(59) = 2395

NongliData(60) = 1179

NongliData(61) = 267415

NongliData(62) = 2635

NongliData(63) = 661067

NongliData(64) = 1701

NongliData(65) = 1748

NongliData(66) = 398772

NongliData(67) = 2742

NongliData(68) = 2391

NongliData(69) = 330031

NongliData(7

老鬼

推薦幾個(gè)EXCEL快捷鍵吧，這比較實(shí)用。CTRL+D，復(fù)制上面單元格的數(shù)據(jù)到下面的單元格。CTRL+R，復(fù)制左邊的數(shù)據(jù)到右邊的單元格。CTRL+SHIFT+下箭頭或右箭頭，從當(dāng)前單元格選至當(dāng)前區(qū)域最下面或最右邊。CTRL+*，選定當(dāng)前區(qū)域。右鍵點(diǎn)擊工作表標(biāo)簽左邊的地方，可以看到當(dāng)前工作簿所有的工作表列表。

老鬼

再推薦幾個(gè)快捷鍵：F2，進(jìn)入單元格編輯狀態(tài)。F4，在相對(duì)引用（如A1）和絕對(duì)引用（如$A$1）間進(jìn)行轉(zhuǎn)換。

test2000

alt+F11可進(jìn)入VBA編輯器

情比金堅(jiān)

Ctrl+；當(dāng)前日期

elawuyou

補(bǔ)充一下ctrl+D 的用法: 選定數(shù)據(jù)所在的單元格及它以下的任意空白單元格,按ctrl+D,可將選定的數(shù)據(jù)復(fù)制到空白單元格中.另外:ctrl+'  復(fù)制上面單元格的數(shù)據(jù)到下面的單元格, 不含格式,且為編輯狀態(tài).

elawuyou

再來(lái)一個(gè): shift+F11 插入新工作表,又快又好.