目前分類:title (5957)

瀏覽方式: 標題列表 簡短摘要

I have received a spreadsheet with columns numbered 1 - 4 to the left of
Column A1. They are locked amp; have a scroll bar at the bottom of the sheet.

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

My data comes in like so:

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


Sorry.. title is strange..

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

if you have saved over the feb one then theirs noting you can do to retrive
it,,,

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

I have a (very) long list, sorted by account code. I would like to write a
macro that splits the list into separate sheets in the workbook, with a

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

I had a consolidated worksheet from 01/01/05 to current,and was requested to
sort by name/date and then subtotal all entries w/o saving the consolidated

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

I would like to be able to enter English pre-decimal currency in an Excel
worksheet - i.e. pounds shillings and pence. Can anyone advise whether this

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

Can I insert the contents of a cell into the page header or footer without
having to use a macro.

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

Hi,
I have a workbook with multiple worksheets. The first 2 worksheets are the

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

i have a data that has dates that show up as 4/25/200, 4/25/2020 and 4/25/200

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

I want to protect all the worksheets
however leave the pivot tables for Filtering

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

not enough system resources to display completely

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


Hi,

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

I am getting the following message when attempting to Merge spreadsheets in
Excel 2002...

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

In column J I have the following formula =IF(E7=quot;quot;;quot;quot;;J5 (E7-F7)/24) and
everything works fine, but my problem is that if a 0 is in column E then the

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

I want to search a cell in a report where supervisors report staffing
actions. When overtime is worked they may note it as O/T, OT or ot. I was

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

What I am trying to do is match 2 lists to get a value. In other words in
sheet1 I have this:

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



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

I am attempting to insert scaled drawings into Excel copied straight from
Microsoft Documant Imaging software (.mdi) and Excel skews the drawing while

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

Adding images to an excel workbook (specifically, dragging GIFs from IE,
don't know if it also happens with File gt; Insert) always increases the XLS

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