Welcome to the archive


No Article
1 Engineering functions – IMD to Z
2 Engineering functions – D to IMC
3 Engineering functions – A to C
4 Date and Time Functions – N to Z
5 Date and Time Functions – A to M
6 Compatibility Functions
7 Array Manipulation Functions
8 How to use the KURT function
9 How to use the HARMEAN function
10 How to use the MAKEARRAY function
11 How to use the BYROW function
12 How to use the BYCOL function
13 How to use the SCAN function
14 How to use the MAP function
15 How to use the REDUCE function
16 How to use the HYPGEOM.DIST function
17 How to track sector performance in the stock market – Excel template
18 How to use the IMPOWER function
19 How to use the asterisk character
20 How to use the VALUETOTEXT function
21 How to use the ARRAYTOTEXT function
22 How to decode URL-encoded strings
23 How to use the IMAGE function
24 How to use the LAMBDA function
25 How to use the REPLACE function
26 How to use the WRAPROWS function
27 How to use the TEXTSPLIT function
28 How to use the TEXTAFTER function
29 How to use the TEXTBEFORE function
30 How to use the STOCKHISTORY function
31 How to use the XMATCH function
32 How to use the LET function
33 How to use the XLOOKUP function
34 How to use the FILTERXML function
35 How to use the ROUND function
36 How to use the RANDARRAY function
37 How to use the SEQUENCE function
38 How to use the SORTBY function
39 How to use the SORT function
40 How to use the FILTER function
41 How to use the UNIQUE function
42 How to solve simultaneous linear equations in Excel
43 How to use the XNPV function
44 How to use the RRI function
45 How to do tiered calculations in one formula
46 How to use the ROUNDDOWN function
47 How to use the ROUNDUP function
48 Excel charts tips and tricks
49 How to use the VDB function
50 How to use the YIELD function
51 How to use the SYD function
52 How to use the TBILLEQ function
53 How to use the TBILLPRICE function
54 How to use the TBILLYIELD function
55 How to use the UNICODE function
56 How to use the UNICHAR function
57 How to use the PERCENTRANK.EXC function
58 How to use the PERCENTRANK.INC function
59 How to use the QUARTILE.EXC function
60 How to use the LOGNORM.DIST function
61 Conditional Formatting Basics
62 How to use the LOG10 function
63 How to use the LOGEST function
64 How to use the LINEST function
65 How to use the GAMMA.DIST function
66 Calculate the number of weeks between given dates
67 How to add chart elements
68 How to use the F.TEST function
69 Excel VBA functions
70 How to use the INTERCEPT function
71 How to use the F.DIST.RT function
72 How to use the F.DIST function
73 How to use the BINOM.INV function
74 How to use the CHISQ.TEST function
75 How to use the COVARIANCE.S function
76 How to use the COVARIANCE.P function
77 How to use the COTH function
78 How to use the XOR function
79 How to use the CHISQ.INV.RT function
80 How to use the CHISQ.INV function
81 How to use the CHISQ.DIST.RT function
82 How to use the CHISQ.DIST function
83 How to use the BINOM.DIST function
84 How to use the BETA.INV function
85 How to use the BETA.DIST function
86 How to use the RANK.EQ function
87 How to use the CONFIDENCE.T function
88 How to use the CONFIDENCE.NORM function
89 How to use the MODE.SNGL function
90 How to use the FLOOR.PRECISE function
91 How to use the CSC function
92 How to use the GROWTH function
93 How to use the ERROR.TYPE function
94 How to use the GCD function
95 How to use the GEOMEAN function
96 How to use the SLOPE function
97 How to use the RANGE.FIND method
98 How to use the SKEW function
99 How to use the PROB function
100 How to use the PHI function
101 How to use the CONCATENATE function
102 Get date ranges from a schedule
103 How to replace part of formula in all cells
104 Copy data from workbooks in folder and subfolders
105 How to position month and year between chart tick marks
106 How to copy non contiguous cell ranges
107 Search for a file in folder and subfolders [UDF]
108 How to use the MUNIT function
109 How to use the RAND function
110 How to use the MULTINOMIAL function
111 How to use the MINIFS function
112 How to use the MINA function
113 How to use the MINVERSE function
114 How to use the NORM.INV function
115 Advanced Excel Chart Techniques
116 How to use the NORM.DIST function
117 How to use the WEBSERVICE function
118 How to create charts in Excel
119 How to use the VAR.S function
120 How to use the VAR.P function
121 How to use the FORECAST.LINEAR function
122 Count cells with text
123 Count rows containing data
124 How to use the BITLSHIFT function
125 How to use the BITAND function
126 How to use the BASE function
127 How to use the AVEDEV function
128 How to use the ATANH function
129 How to use the ATAN2 function
130 How to use the ATAN function
131 How to use the ASINH function
132 How to use the ASIN function
133 How to use the ASC function
134 How to use the ACOTH function
135 How to use the ACOT function
136 How to use the ACOSH function
137 How to use the ACOS function
138 How to use the NA function
139 How to use the TYPE function
140 How to use the TRUNC function
141 How to use the TRIMMEAN function
142 How to use the TREND function
143 How to use the SERIESSUM function
144 How to use the SECH function
145 How to use the COT function
146 How to use the COSH function
147 How to use the SINH function
148 How to use the TANH function
149 How to use the SUMXMY2 function
150 How to use the SUMX2PY2 function
151 How to use the SUMX2MY2 function
152 How to use the SUMSQ function
153 How to use the STDEVPA function
154 How to use the STANDARDIZE function
155 How to use the STDEV.S function
156 How to use the STDEV.P function
157 How to use the SEC function
158 How to use the RANK.AVG function
159 How to use the QUARTILE.INC function
160 How to use the FLOOR.MATH function
161 How to sum overlapping time
162 How to use the FIXED function
163 How to use the FACTDOUBLE function
164 How to use the EXPON.DIST function
165 How to use the ENCODEURL function
166 How to use the DECIMAL function
167 How to use the CORREL function
168 How to use the CONCAT function
169 How to use the CEILING function
170 How to use the AVERAGEA function
171 How to use the AREAS function
172 How to use the LCM function
173 How to use the SWITCH function
174 How to use the STDEVA function
175 How to use the SHEETS function
176 How to use the SHEET function
177 How to use the MROUND function
178 How to use the NOT function
179 How to use the SQRT function
180 How to use the SIGN function
181 How to use the T function
182 How to use the N function
183 How to use the MODE.MULT function
184 How to use the MEDIAN function
185 How to use the LOG function
186 How to use the LN function
187 How to use the INFO function
188 How to use the PERMUTATIONA function
189 How to use the COMBINA function
190 How to use the PRODUCT function
191 Rearrange values in a cell range to a single column
192 Get the latest revision
193 How to use the TRUE function
194 How to use the DEGREES function
195 How to use the RADIANS function
196 How to use the PI function
197 How to use the FORMULATEXT function
198 How to use the ISFORMULA function
199 How to use the ISODD function
200 How to use the ISERR function
201 How to use the FIND function
202 How to use the ISNA function
203 How to use the ISREF function
204 How to use the ISNONTEXT function
205 How to use the ISLOGICAL function
206 How to use the ISTEXT function
207 How to use the ISERROR function
208 How to use the ISBLANK function
209 How to use the POWER function
210 How to extract numbers from a cell value
211 How to use the VALUE function
212 How to use the DO LOOP statement
213 How to use the TAN function
214 How to use the COS function
215 How to use the SIN function
216 How to use the EVEN function
217 How to use the EXP function
218 How to use the RANDBETWEEN function
219 How to use the FALSE function
220 How to use the FACT function
221 How to use the IFNA function
222 How to use the IFS function
223 How to use the INT function
224 How to use the CLEAN function
225 How to use the COMBIN function
226 How to use the PERMUT function
227 How to use the LEN function
228 How to use the COUNTBLANK function
229 How to use the COUNTA function
230 How to use the COLUMNS function
231 How to use the ROWS function
232 How to use the MAX function
233 How to use the MAXIFS function
234 How to use the LARGE function
235 How to use the CELL function
236 How to use the COUNT function
237 How to use the CHAR function
238 How to use the CODE function
239 How to use the COLUMN function
240 How to use the FOR NEXT statement
241 How to use the AVERAGEIFS function
242 How to use the AVERAGEIF function
243 How to use the AGGREGATE function
244 How to use the ADDRESS function
245 How to use the ISNUMBER function
246 How to use the LOWER function
247 How to use the REPT function
248 How to use the SUBSTITUTE function
249 How to use the UPPER function
250 How to use the EXACT function
251 How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
252 How to use the TRIM function
253 How to remove numbers from a cell value
254 How to use the ABS function
255 Extract specific word based on position in cell value
256 How to use the RIGHT function
257 How to use the LEFT function
258 How to use the MID function
259 How to use the MIN function
260 How to use the SUMIFS function
261 How to use the CHOOSE function
262 Count cells containing text from list
263 AVERAGE based on criteria
264 If cell contains multiple values
265 SMALL function – INDEX MATCH
266 How to ignore zeros using the SMALL function
267 SMALL function – multiple conditions
268 SMALL function for text
269 AVERAGE ignore NA()
270 How to AVERAGE time
271 AVERAGE ignore blanks
272 How to use the AVERAGE function
273 SMALL function ignore duplicates
274 SUMPRODUCT and nested IF functions
275 SUMPRODUCT if not blank
276 SUMPRODUCT and IF function
277 SUMPRODUCT – multiple criteria
278 INDEX MATCH – Case sensitive
279 Excel formula not working
280 INDEX MATCH – multiple results
281 Match two columns and return another value on the same row
282 If cell equals value from list
283 How to use the SUBTOTAL function
284 If cell contains text from list
285 IF with OR function
286 INDEX MATCH with multiple criteria
287 How to use the COUNTIF function to count not blank cells
288 If cell contains text
289 How to use the OR function
290 How to use the AND function
291 Use IF + COUNTIF to evaluate multiple conditions
292 IF function with AND function – multiple conditions
293 How to use nested IF functions
294 How to use the HYPERLINK function
295 How to use the TEXT function
296 How to use the SUMIF function
297 Distribute values across numerical ranges
298 How to create running totals
299 Rearrange values using formulas
300 User opens or closes a workbook creates an event
301 How to extract a case sensitive unique list from a column
302 Count unique distinct values based on a condition
303 Extract a list of alphabetically sorted duplicates based on a condition
304 Extract duplicate values with exceptions
305 Filter duplicate values based on criteria
306 Find last value in a column
307 Lookup and match last value – reverse lookup
308 Use VLOOKUP and return multiple values sorted from A to Z
309 Concatenate unique distinct values
310 How to use the SUM function
311 How to use the HLOOKUP function
312 How to use the VLOOKUP function
313 Partial match and return value with highest level
314 Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses
315 Count matching strings using regular expressions
316 Split search value using a delimiter and search for each substring
317 Fetching values from ThingSpeak programmatically
318 How to use Excel Tables
319 Rotating unique groups with no repeat
320 Time sheet for work
321 Extract cell references from a formula
322 How to extract rows containing digits [Formula]
323 How to use the LIKE OPERATOR
324 Calendar – monthly view
325 How to generate a round-robin tournament
326 List permutations with repetition and how many to choose from
327 How to use DIALOG BOXES
328 List all permutations with a condition
329 How to use Pivot Tables – Excel’s most powerful feature and also least known
330 How to use the TEXTJOIN function
331 Working with ARRAY VARIABLES (VBA)
332 How to calculate and plot pivots on an Excel chart
333 Count identical values if they are on the same row
334 Compare two columns in different worksheets
335 Sort values by corresponding text arranged in a column
336 Sort items by adjacent number in every other value
337 Multiply numbers in each row by entire cell range
338 Resize a range of values (UDF)
339 Follow stock market trends – trailing stop
340 Follow stock market trends – Moving Average
341 Dynamic stock chart
342 Find and return the highest number and corresponding date based on a condition
343 How to add horizontal line to chart
344 A beginners guide to Excel array formulas
345 How to color chart bars based on their values
346 Count overlapping days across multiple date ranges
347 How to improve your Excel Chart
348 How to use the TRANSPOSE function
349 Calculate time between time zones
350 Find and replace strings in file names, folder name and subfolders
351 Sum numerical ranges between two numbers
352 Sort based on frequency row-wise
353 Count overlapping days in multiple date ranges, part 2
354 Count overlapping days in multiple date ranges
355 Find empty dates in a set of date ranges
356 Dynamic scoreboard
357 Working with overlapping date ranges
358 How to calculate overlapping time ranges
359 How to build a Team Generator – different number of people per team
360 Working with LIST BOXES (Form Controls)
361 Split expenses calculator
362 How to count repeating values
363 List all hyperlinks in worksheet programmatically
364 How to automatically add new items to a drop down list
365 How to use the QUOTIENT function
366 Return all combinations
367 Find numbers closest to sum
368 Filter duplicate files in a folder and subfolders
369 Compare file names in two different folder locations and their sub folders
370 How to save specific multiple worksheets to a pdf file programmatically
371 Find cells containing formulas with literal (hardcoded) values
372 How to use the LOOKUP function
373 How to use the INDIRECT function
374 Find the most/least consecutive repeated value [VBA]
375 How to use the TEXTTOCOLUMNS method
376 How to count the number of values separated by a delimiter
377 Extract the most repeated adjacent values in a column
378 Search for a sequence of cells based on wildcard search
379 Search for a sequence of values
380 Search all workbooks in a folder and sub folders – VBA
381 Working with comments – VBA
382 Add pictures to a chart axis
383 How to group items by quarter using formulas
384 Working with Excel tables programmatically
385 How to highlight row of the selected cell programmatically
386 A quicker A * pathfinding algorithm
387 How to use the MOD function
388 Finding the shortest path – A * pathfinding
389 Working with classic ciphers in Excel
390 Move data to workbooks
391 How to use the Subtotal tool
392 Print screen the entire worksheet
393 Highlight unique values in a filtered Excel table
394 Customize Excel maze
395 Solve a maze programmatically in Excel
396 Build a maze programmatically in Excel
397 Merge tables based on a condition
398 Lookup value based on two critera – second criteria is the adjacent value and its position in a given list
399 Find last matching value in an unsorted list
400 Multi-level To-Do list template
401 How to animate an Excel chart
402 Sort by multiple columns
403 Search all workbooks in a folder
404 All you need to know about calculating NAV units for your stock portfolio
405 Lookup and return multiple sorted values based on corresponding values in another column
406 Customize the ribbon and how to add your macros
407 Identify rows of overlapping records
408 Remove print preview lines (Page Breaks)
409 Compare two columns and extract differences
410 How to filter chart data
411 Working with TEXT BOXES [Form Controls]
412 Show / hide a picture using a button
413 Wildcard lookups and include or exclude criteria
414 Lookup with any number of criteria
415 Hide specific worksheets programmatically
416 How to use the Scroll Bar
417 Count Conditionally Formatted cells
418 Count cells based on background color
419 Find earliest and latest overlapping dates in a set of date ranges based on a condition
420 How to select and delete blank cells
421 Prevent duplicate records in a worksheet
422 Color chart columns based on cell color
423 Count unique distinct values by cell color
424 Pivot Table calendar
425 Highlight date ranges overlapping selected record [VBA]
426 Practice basic arithmetic calculations in Excel
427 Which Excel files in folder are password protected?
428 Count text string in all formulas in a worksheet [VBA]
429 Easily select data using hyperlinks
430 Navigate to first empty cell using a hyperlink formula
431 How to use the IFERROR function
432 Create a hyperlink linked to the result of a two-dimensional lookup
433 How to generate random numbers and text
434 Compare data in an Excel chart using drop down lists
435 Locate a shape in a workbook
436 Hover with mouse cursor to change stock in a candlestick chart
437 Find all sequences of consecutive dates
438 How to use the FREQUENCY function
439 Heat map using pictures
440 How to use the SUMPRODUCT function
441 How to build an interactive map in Excel
442 How to use the SEARCH function
443 Yet another Excel Calendar
444 How to use the MMULT function
445 How to use the SMALL function
446 Working with FILES
447 Assign records unique random text strings
448 How to use the ROW function
449 Highlight duplicates in a filtered Excel Table
450 How to use the COUNTIFS function
451 How to use the IF function
452 How to use the COUNTIF function
453 Units contained in a range that overlap another range
454 How to use the MATCH function
455 How to use the INDEX function
456 How to change a picture in a worksheet dynamically [VBA]
457 Count specific multiple text strings in a given cell range
458 Move a shape [VBA]
459 How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
460 Convert array formula to a regular formula
461 Highlight group of values in an x y scatter chart programmatically
462 Highlight a data series in a chart
463 Highlight events in a yearly calendar
464 Repeat values across cells
465 Merge two relational data sets
466 Lookup multiple values in one cell
467 Run a Macro from a Drop Down list [VBA]
468 Advanced Techniques for Conditional Formatting
469 Prevent overlapping date and time ranges using data validation
470 Group rows based on a condition
471 Working with date ranges
472 Analyze trends using pivot tables
473 Compare the performance of your stock portfolio to S&P 500 using Excel
474 How to use VLOOKUP/XLOOKUP with multiple conditions
475 Highlight lookups in relational tables
476 Working with three relational tables
477 Extract unique distinct values from a relational table
478 How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
479 Lookups in relational tables
480 Copy worksheets in active workbook to new workbooks
481 Filter values that exists in all three columns
482 Search related table based on a date and date range
483 Excel calendar
484 Populate drop down list with filtered Excel Table values
485 Use drop down lists and named ranges to filter chart values
486 Shift Schedule
487 Extract cell references populated with values [VBA]
488 How to use mouse hover on a worksheet [VBA]
489 Sort values in a cell based on a delimiting character
490 Macro creates links to all sheets, tables, pivot tables and named ranges
491 Count unique distinct values in a filtered Excel defined Table
492 Create links to all sheets in a workbook programmatically
493 Create new worksheets programmatically based on values in a cell range [VBA]
494 Change chart axis range programmatically
495 List files in folder and create hyperlinks (VBA)
496 Plot buy and sell points in an Excel Chart based on two moving averages
497 Add buy and sell points to a stock chart
498 How to create an interactive Excel chart [VBA]
499 Prepare data for Pivot Table – How to split concatenated values?
500 Lookup multiple values across columns and return a single value
501 Excel template: Getting Things Done [VBA]
502 Create date ranges that stay within month
503 Add values to a two-dimensional table based on conditions [VBA]
504 Unique distinct records sorted based on count or frequency
505 Count groups of repeated values per row
506 Use a drop down list to filter and concatenate unique distinct values
507 Add or remove a value in a drop down list programmatically
508 Open Excel files in a folder [VBA]
509 Auto populate a worksheet
510 Partial match and return multiple adjacent values
511 Toggle a macro on/off using a button
512 Use a drop down list to display data in worksheet header [VBA]
513 Automate data entry [VBA]
514 Apply drop-down lists dynamically
515 Working with Conditional Formatting formulas
516 How to create random numbers, text strings, dates and time values
517 Dependent drop-down lists in multiple rows
518 Watch schedule that populates vacation time
519 Auto resize columns as you type
520 Copy a dynamic cell range [VBA]
521 Label groups of duplicate records
522 Working with COMBO BOXES [Form Controls]
523 Use a drop down list to search and return multiple values
524 How to create permutations
525 Extract unique distinct values in a filtered list
526 Add checkboxes and copy values – VBA
527 Count cells between specified values
528 Add values to a regular drop-down list programmatically
529 Rearrange data
530 Extract unique distinct values based on a filtered Excel defined Table
531 Two-way lookup in multiple cross reference tables simultaneously
532 Remove common records between two data sets
533 Filter unique distinct values, sorted and blanks removed from a range
534 Vlookup across multiple sheets
535 Count unique distinct values that meet multiple criteria
536 Vlookup a cell range and return multiple values
537 How to save custom functions and macros to an Add-In
538 Search each column for a string each and return multiple records – OR logic
539 How to compare two data sets
540 VLOOKUP – Return multiple unique distinct values
541 Filter unique distinct records case sensitive
542 Create a dynamic named range
543 How to create a dynamic pivot table and refresh automatically
544 Bill reminder in excel
545 Running totals based on criteria
546 How to highlight differences and common values in lists
547 Analyze word frequency in a cell range
548 Fuzzy lookups
549 Fuzzy VLOOKUP
550 A Comprehensive Guide to Splitting Text in Excel
551 Filter strings containing a given substring in a cell range
552 Filter overlapping date ranges
553 Concatenate cell values
554 Tracking a stock portfolio #2
555 Create a drop down calendar
556 Monthly calendar template
557 Count unique distinct records
558 Compare tables: Filter records occurring only in one table
559 Lookup and return multiple values concatenated into one cell
560 Create a Print button – macro
561 Save invoice data – VBA
562 Extract unique distinct values based on the 4 last characters
563 Apply dependent combo box selections to a filter
564 Sort rows based on frequency and criteria
565 True round-robin tournament
566 Create a random playlist
567 Team Generator
568 Filter unique strings from a cell range
569 Vlookup with multiple matches returns a different value
570 Extract a unique distinct list and sum amounts based on a condition
571 Populate cells dynamically in a weekly schedule
572 Create numbers based on numerical ranges
573 Find empty hours in a weekly schedule
574 Create dependent drop down lists containing unique distinct values
575 Extract a unique distinct list sorted from A to Z ignore blanks
576 Extract dates from overlapping date ranges
577 Convert date ranges into dates
578 List dates outside specified date ranges
579 Plot date ranges in a calendar
580 How to use absolute and relative references
581 Identify overlapping date ranges
582 Merge two columns with possible blank cells
583 List all unique distinct rows in a given month
584 Filter duplicates within same date, week or month
585 Remove duplicates within same month or year
586 Automate net asset value (NAV) calculation on your stock portfolio
587 Split data across multiple sheets – VBA
588 Merge Ranges Add-In
589 Match two criteria and return multiple records
590 Create number series
591 Extract unique distinct values if the value contains the given string
592 How to return a value if lookup value is in a range
593 VLOOKUP/XLOOKUP of three columns to pull a single record
594 Excel solver examples
595 Identify numbers in sum using Excel solver
596 Formula for matching a date within a date range
597 Find the most recent date that meets a particular condition
598 Most frequent value between two dates
599 Create a quartely date range
600 5 easy ways to VLOOKUP and return multiple values
601 Extract unique distinct values sorted based on sum of adjacent values
602 Filter unique values from a cell range
603 Filter unique values sorted from A to Z
604 Extract all rows from a range that meet criteria in one column
605 Create unique distinct list sorted based on text length
606 How to list unique distinct values sorted by frequency
607 Extract unique distinct values sorted from A to Z
608 Extract numbers from a column
609 Extract unique distinct values A to Z from a range and ignore blanks
610 Find min and max unique and duplicate numerical values
611 Reverse a list ignoring blanks
612 Perform multiple partial matches and return records – AND logic
613 Filter values in common between two cell ranges
614 Filter values occurring in range 1 but not in range 2
615 Sort a range from A to Z [Array formula]
616 Extract duplicates from a multi-column cell range
617 Search for a text string in a data set and return multiple records
618 Count a specific text string in a cell
619 Sort text cells alphabetically from two columns
620 Merge cell ranges into one list
621 How to perform a two-dimensional lookup
622 Extract a list of duplicates from three columns combined
623 Extract a list of duplicates from a column
624 Extract a unique distinct list from three columns
625 Extract a unique distinct list from two columns
626 How to create date ranges in Excel
627 Find missing numbers
628 Count unique distinct values
629 Split values equally into groups
630 Populate drop down list with unique distinct values sorted from A to Z
631 How to highlight duplicate values
632 Lookup the nearest date
633 Partial match with two conditions and return multiple results
634 Filter unique distinct values based on a date range
635 Advanced Date Highlighting Techniques in Excel
636 How to rank text uniquely without duplicates
637 Sort column based on frequency
638 Partial match for multiple strings – AND logic
639 Sum unique numbers
640 Extract a unique distinct list sorted from A to Z
641 How to quickly find the maximum or minimum value [Formula]
642 Working with unique values
643 5 easy ways to extract Unique Distinct Values
644 Sort a column alphabetically
645 Extract unique distinct values from a multi-column cell range
646 Calculate machine utilization
647 Extract a unique distinct list and ignore blanks
648 Extract records between two dates
649 Extract shared values between two columns
650 How to extract email addresses from an Excel sheet
651 Filter unique distinct records
652 What values are missing in List 1 that exists i List 2?
653 Find closest value
654 How to use the OFFSET function
655 Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
656 Find the smallest number in a list that is larger than a given number
657 Print consecutive page numbers across multiple worksheets
658 Excel chart components
659 How to improve worksheet readability in Excel