PIXNET Logo登入

software

跳到主文

software

部落格全站分類:數位生活

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 7月 20 週四 200620:08
  • Column Problem Help Please!

Hi,
I am creating a spreadsheet for work in which the start and finish times for
employees are recorded. I am using the following formula:
=IF(E4=$C5,quot;Startquot;,(IF(E4=$D5,quot;Finishquot;,quot;-quot;)))
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • macro to print files from a list of links

I am trying to develop a macro to read a list of links from an excel
spreadsheet and print each of the files. The number of files in the
list may change.
ANy ideas?Are these links to files on your PC on on the internet?
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(5)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • print on a sinlge page

i have 4-5 cloumns and quite a large no. of rows.i want whole print on a
single sheet in column wisee..like i have 4 columns and 1256 rows..so i want
to know the print command so that i can get whole print on a single
page..from where the first page finished then on the very same page then next
rows start from the right hand sides columns..i know we can do that by coping
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • How to create pop-up message in Excel before Printing

Hi All,
I have a huge file that consumes reams of paper when printed. So I want
a message box to appear when people click on the print icon in Excel
(or click on File gt;gt; Print or Ctrl-P), suggesting that they should only
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Counting of tickets that have certain criteria

Hi
I am currently working on producing reports from a data dump. One of the
reports is based on counting how many incidents are there of a certain
criteria. Easy enough except the criteria is across 4 columns (see below)
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(2)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • I NEED A HELP IN EXCEL

Hi
I am new in EXCEL. I am tired to lookup the function of the following :
I need to know a correct formulae to lookup my stock report. I created a
table that i am entering everyday sale in every cell in vertical order. when
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(4)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Help for Lotus 1-2-3 users in Excel 2003

In older versions of Excel, there used to be a way to get Excel to
quot;translatequot; Lotus 1-2-3 commands into Excel keystrokes. Anyone know if this
is still possible? Standard Help doesn't answer this.
--
Djhawk
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • How do I create a conditional formula that hides a complete row o.

How do I create a conditional formula that hides a complete row or rows if a
value = 0? I want the rows to disappear so that I can print out only the
information for rows that have information in them.
If you are going to use a formula it is not possible to hide, you can use
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • How do I copy an Excel chart to paste into InDesign?

I have a chart in MS Excel 2000 and when I select it, copy it, and then paste
it into InDesign CS2, the labels on the lower horizontal axis do not come
along. Is there some special way to do this that I'm missing?
1. Are you pasting into a frame? If so the default setting is to crop
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • auto fit column width and row height

Is it true that their is a particular font best for auto fitting column width
and row height in Excel 2003? If so what is it?
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(1)

  • 個人分類:title
▲top
«1...3188318931903197»

個人資訊

software
暱稱:
software
分類:
數位生活
好友:
累積中
地區:

熱門文章

  • (18)aa ab ac....ax ay az....ba bb bc....zx zy zz ?
  • (2)=SUMPRODUCT(--(('Access Data'!B$1:aaaa)=$A5))
  • (1)need help with macros
  • (6)Where is the tick icon in Excel
  • (1)Trouble Forecasting
  • (3)i cannot get favorites in excel 2003
  • (2)To show quot;0quot; instead of #N/A
  • (2) OK, Sold My 89 Les Paul, What Should I Get?
  • (74) Who makes the best pedal mods?
  • (1) Horribly confusing wiring instructions

文章分類

  • title (6,014)
  • title (5,999)
  • title (6,022)
  • title (5,957)
  • title (4,957)
  • title (3,013)
  • 未分類文章 (1)

最新文章

  • PICS! 2X12 Cab Reviews Mesa vs. Bogner
  • Q's about Korean PRS with P-90's.
  • aNY NEW duncan pickups next year ?
  • Fernandes Ravelle (Dave Kushner)
  • Another SX Tele question
  • GAS got the best of me yesterday....came home with new GEETAR!
  • Neck strength on Vintage ES330's amp; ES335's...
  • Awesome amp sampler site.
  • anyone try a fishman powerbridge?
  • Got My Custom Made Chassis (Pics)

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣

  • 本日人氣:
  • 累積人氣: