I created an Excel spreadsheet and saved it to a network drive. When other
people edit the spreadsheet and try to save it they get a message saying the
file is set as read only. They are directed to save the file as another name.
The save dialog box comes up and saves the file as a quot;copy ofquot; the original.
If you right click on the file and go to properties the read only attribute
(繼續閱讀...)

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

▲top
Here's one play using non-array formulas which might also deliver this ..
A sample construct is available at:
www.savefile.com/files/9870225
Multiple search amp; auto-extract rows from 3 sheets based on key charge code
(繼續閱讀...)

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

▲top
Is there a way to insert multiple rows at a single time? Let me see if I can
explain.
I have an existing worksheet contain several hundreds rows on data. I want
to insert 16 new rows between each existing row of data. I can do this by
going to each row and inserting the rows but I was hoping there would be a
(繼續閱讀...)

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

▲top
i have received an excell document and cant open it, can anyone help ,
many thanks
ray
Go to the following URL at Microsoft.com to acquire the free Excel reader:
(繼續閱讀...)

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

▲top

I am sure this is possible in a macro, but I'm only just learning them
In a workbook I have 2 sheets one containing last months data (lstmnth)
and one containing this months data (thismnth)
(繼續閱讀...)

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

▲top

Use arrow keys to navigate to where you want to copy.
Hold shift down and use arrow keys to highlight cell(s)
Hit Ctrl C to copy
(繼續閱讀...)

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

▲top
第一頁 « 2662 2663 2664
Blog Stats
⚠️

成人內容提醒

本部落格內容僅限年滿十八歲者瀏覽。
若您未滿十八歲，請立即離開。

已滿十八歲者，亦請勿將內容提供給未成年人士。